Excel Match Function – How To Use

Excel provides many formulas for finding a particular string or text in an array. One such function is MATCH, in fact Match function is designed to do a lot more than this. Today we are going to learn how to use the Excel Match function. Basically what match function does is, it scans the whole array range in order to find the specified text and … [Read more...]

SubTotal Function In Excel – How to Use

Subtotal Function in Excel is a wonderful formula that can be used to perform some specific arithmetic and logical operation on a defined range of cells.Microsoft Excel defines Subtotal Function as “It returns a subtotal in a list or database”.Subtotal formula takes two arguments:1. Operation Code2. Range of Cells.In the below … [Read more...]

Transpose Function in Excel – How to Use

The term transpose literally means swapping rows and columns. And similarly transpose function in excel flips rows into columns and vice-versa. Transpose is an array function i.e. it can only be applied on a range of cells. And today in this post I will be guiding you on how to use transpose functionality in excel.What are Array Functions and why … [Read more...]

Excel Indirect Function – How to Use

Excel Indirect Function is one of the most useful functions in Microsoft Excel. Indirect function takes a cell reference in the form of a string, then it evaluates the reference and shows its content. This gives you a better way to deal with variable cell references.Excel Indirect Function Syntax:The syntax of indirect function is quite … [Read more...]

Excel SUMPRODUCT Function – How To Use

On hearing the name of Excel SUMPRODUCT Function for the first time, it looks like some useless formula that can do some predefined sum and product operations. But actually it’s far from that definition. In fact it is a very useful function if you need to analyse the data of two or multiple arrays in excel.How Excel Defines SUMPRODUCT … [Read more...]