Introduction OFFSET function in excel is a reference function. This function is used to refer data from a cell or range of cells to a defined range. The number of rows and columns to be returned is also specified. Reference returned by offset function is in parts: start point, row and column offset and height … Read more
Introduction LOOKUP function in excel is a lookup and reference function. This function is used to lookup or approximately match data in single column or single row and retrieve value from corresponding column or row. This function has two forms, one is called vector and the other one is called array form. Vector form Syntax … Read more
Introduction TRANSPOSE function in excel is a lookup/reference function. This function is used to rotate or flip or switch cells and range of cells without duplicating the data. When copy and pasting of data is done, it leads to duplication of data, by using TRANSPOSE function this problem can be avoided. Syntax =TRANSPOSE(array) Argument Array: … Read more
Introduction GETPIVOTDATA function in excel is a lookup function. This function is used to return specific data from a pivot table. It uses pivot table structure instead of reference cell reference for retrieving data. Syntax =GETPIVOTDATA (Data_Field, Pivot_Table, [field1,item1]) Argument Data_Field: It is the name of the field entered in quotation marks which contains the … Read more
Introduction FORMULATEXT function in excel is a Math/Trig function. It is a worksheet function. This function is used to retrieve a formula from a reference in form of a text string. Syntax =FORMULATEXT(Reference) Arguments Reference- t is the reference made to a range or cell. Keynotes Reference argument can be from other worksheet also. If … Read more
Introduction MATCH function in excel is a lookup function. It helps in locating cell number corresponding to a lookup value of a row, column or table. It does this by searching for specific value in a range of cells and returns position of value. For Example, if the range A3:A6 have the values 10, 15, … Read more
Introduction HYPERLINK function in excel a shortcut function that creates a shortcut in the cell in which it is used. This shortcut may contain a reference to another cell of the same worksheet or another worksheet OR may contain a link to a network, internet, web, and intranet. When one clicks on the cell containing … Read more
Introduction ROWS function in excel is a lookup or reference function. It provides us with number of rows in an array or reference. We have to enter a range in Excel format and it returns number of rows present in that range. For example row A1:A6 gives 6 as the result. Syntax =ROWS(Array) Arguments … Read more
Introduction ROW function in excel is a reference function. It returns the row number of a cell to which reference is made. If we provide no reference than function returns the reference value of the cell in which the function is written. For example =ROW(A9) returns 9 as A9 is the 9th row in Excel. … Read more
Introduction INDIRECT function in excel is a reference function. It is used to change a text string to a valid reference in formula. It can be used when a reference in form of text need to be changed into a valid reference. This reference does not change when rows and columns are added into the … Read more