How to use Excel TRANSPOSE function

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

How to use Excel GETPIVOTDATA function

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

How to use Excel ROWS function

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