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.