ListenData - Excel Functions

Home » Excel Functions

Showing posts with label Excel Functions. Show all posts

Excel : OFFSET Function with Examples

In this tutorial, you will learn how to apply OFFSET function in MS Excel. The Excel syntax for the OFFSET function is: = OFFSET ( ...

Suppose you are asked to count the number of cells in a range containing a particular word, example "hi" (without double quotes). ...

Situation You are asked to update a table wherein VLOOKUP function needs to be entered in hundreds of columns. It is not possible to ...

Explanation The Hlookup function looks for a value in the top row of a table and then returns a value in the same column from a row y...

This tutorial explains the VLOOKUP function in layman's language and how to use it in Excel, along with examples. VLOOKUP: Introductio...

This tutorial explains how to find the smallest value in Excel based on a single or multiple conditions. Suppose you have data for products...

This tutorial covers how to find out the maximum value based on a single or multiple criteria in Excel. Suppose you have data for products,...

Excel MID Function Explanation The MID function extracts a portion of text, starting in the middle of text. Syntax The s...

Explanation : The CHOOSE function commands excel to activate a value or formula in a list of values or formulas. Syntax : = CHOOSE (...