New Functions in 2021
Excel 2021 introduced 11 new worksheet functions.
| ARRAYTOTEXT | Returns the contents of an array or cell range converted into text. |
| 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. |
| VALUETOTEXT | Returns the text from any specified value. |
| 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. |
| ARRAYTOTEXT Returns the contents of an array or cell range converted into text. |
| 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. |
| VALUETOTEXT Returns the text from any specified value. |
| 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. |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext