How to use XLOOKUP Function in Excel
by 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 …
Category: Lookup and reference
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 …