Excel INDIRECT Function

INDIRECT Function

The indirect function in excel returns a reference to a range. We can use this function to create a reference that won't change if row or columns are inserted in the worksheet. Or, cause it to create a reference from letters and numbers in other cells.
The INDIRECT function has two arguments:

indirect formula in excel

1. ref_text: A cell reference or text string (or both), that create the range reference. The referenced range can be a cell, a range of cells, or a named range.

1. a1: TRUE or FALSE. Does the reference use A1 reference style? If this argument is TRUE, or omitted, the ref_text is A1 style. If the argument is FALSE, the ref_text is R1C1 style.

Indirect Function Excel

Excel Function-Match

 Excel Function:Match

This DataWitzz tutorial will explain you about MATCH function of excel.Let us first start with the functionality MATCH,it searches for a value in an array and returns the relative position of that value.
It is built-in function of excel and will come under lookup/reference category.

Syntax:=Match(lookup value,array in which we want to find the position,[Match_Type])

Match_Type is optional and three values can be used as mentioned below:

  

Different COUNT function in Excel

difference between absolute and relative reference in excel

COUNT is very important function in excel and it is being used very frequently.There are five COUNT(count,counta,countblank,countif,countifs) functions which is being used in excel.I will explain every function one by one and have also shared a video with full explanation.

 

Count: This function counts the number of numeric entries in a list. It will ignore blanks, text and errors.

Syntax: =COUNT(Range1,Range2,Range3...................,RangeN)