New Functions in Office 365

Office 365 introduces 10 new worksheet functions.

FIELDVALUEReturns the field data from a Stocks or Geography linked data type.
FILTERReturns the array of data in a range that satisfies multiple conditions.
RANDARRAYReturns the array of random numbers between 0 and 1.
SEQUENCEReturns the array of sequential numbers.
SINGLEReturns the value from a cell range which is the intersection of a row OR a column.
SORTReturns the array of data in a range that has been sorted.
SORTBYReturns the array of data in a range that has been sorted and satisfies multiple conditions.
UNIQUEReturns the array of unique values in a list, table or cell range.
XLOOKUPReturns the value in the same row after finding a matching value in any column.
XMATCHReturns the position of a value in a list, table or cell range.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext