Excel Functions 365 New Functions

Office 365 introduces 10 new worksheet functions.

FIELDVALUE	Returns the field data from a Stocks or Geography linked data type.
FILTER	Returns the array of data in a range that satisfies multiple conditions.
RANDARRAY	Returns the array of random numbers between 0 and 1.
SEQUENCE	Returns the array of sequential numbers.
SINGLE	Returns the value from a cell range which is the intersection of a row OR a column.
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 and satisfies multiple conditions.
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.

FIELDVALUE Returns the field data from a Stocks or Geography linked data type.
FILTER Returns the array of data in a range that satisfies multiple conditions.
RANDARRAY Returns the array of random numbers between 0 and 1.
SEQUENCE Returns the array of sequential numbers.
SINGLE Returns the value from a cell range which is the intersection of a row OR a column.
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 and satisfies multiple conditions.
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.