August 1, 2021

## How to use XLOOKUP Function in Excel

The Excel XLOOKUP function is a modern and flexible replacement for older functions like VLOOKUP, HLOOKUP, and LOOKUP.  XLOOKUP supports approximate and exact matching, wildcards …

## How to use XMATCH Function in Excel

The Excel XMATCH function performs a lookup and returns a position in vertical or horizontal ranges. It is a more robust and flexible successor to the …

## How to use UNIQUE Function in Excel

The Excel UNIQUE function returns a list of unique values in a list or range. Values can be text, numbers, dates, times, etc. Syntax:= UNIQUE …

## How to use TRANSPOSE Function in Excel

Transpose function in excel is used to rotate the values or switch the values from rows to columns and columns to rows, as this function …

## How to use SORTBY Function in Excel

The Excel SORTBY function sorts the contents of a range or array based on the values from another range or array. The range or array …

## How to use RTD Function in Excel

Microsoft Excel provides a new worksheet function, RTD, that allows you to call a Component Object Model (COM) Automation server for the purpose of retrieving …

## How to use SORT Function in Excel

The Excel SORT function sorts the contents of a range or array. Values can be sorted by one or more columns. SORT returns a dynamic …

## How to use ROWS Function in Excel

In simple words “ROWS” function in excel returns the count of the number of rows selected in the range. It is different from the row …

## How to use ROW Function in Excel

Row function in excel is a worksheet function in excel which is used to show the current index number of the row of the selected …

## How to use OFFSET Function in Excel

The Excel OFFSET function returns a reference to a range constructed in parts: a starting point, a row and column offset, and a final height …