New Functions in 2021
Excel 2021 introduced 9 new worksheet functions.
FILTER | Returns the array of data in a range that satisfies multiple conditions. |
LET | Returns the result of a formula that can use variables. |
RANDARRAY | Returns the array of random numbers between 0 and 1. |
SEQUENCE | Returns the array of sequential numbers. |
SORT | Returns the array of data in a range that has been sorted. |
SORTBY | Returns the array of data in a range that has been sorted based on the values in a corresponding range. |
UNIQUE | Returns the array of unique values in a list, table or cell range. |
XLOOKUP | Returns the value in the same row after finding a matching value in any column. |
XMATCH | Returns the position of a value in a list, table or cell range. |
FILTER Returns the array of data in a range that satisfies multiple conditions. |
LET Returns the result of a formula that can use variables. |
RANDARRAY Returns the array of random numbers between 0 and 1. |
SEQUENCE Returns the array of sequential numbers. |
SORT Returns the array of data in a range that has been sorted. |
SORTBY Returns the array of data in a range that has been sorted based on the values in a corresponding range. |
UNIQUE Returns the array of unique values in a list, table or cell range. |
XLOOKUP Returns the value in the same row after finding a matching value in any column. |
XMATCH Returns the position of a value in a list, table or cell range. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext