New Functions in Microsoft 365

You may not have (or see) all of these because some of them are very new and only available to Office Insiders at the moment.

ARRAYTOTEXTReturns the text representation of an array.
BYCOLReturns the results from applying a LAMBDA function to each column in an array.
BYROWReturns the results from applying a LAMBDA function to each row in an array.
FIELDVALUEReturns the field data from a Stocks or Geography linked data type.
ISOMITTEDReturns the value True or False depending whether the value in a LAMBDA is missing.
LAMBDAReturns the results of a formula added as a named range.
MAKEARRAYReturns the array calculated by applying a LAMBDA function.
MAPReturns the array formed by applying a map using a LAMBDA function.
REDUCEReturns the total value after reducing an array by applying a LAMBDA function.
SCANReturns the array after appliying a LAMBDA function to each value and returns an array.
STOCKHISTORYReturns the historical data about a financial instrument.
VALUETOTEXTReturns the text from any specified value.
ARRAYTOTEXT
Returns the text representation of an array.
BYCOL
Returns the results from applying a LAMBDA function to each column in an array.
BYROW
Returns the results from applying a LAMBDA function to each row in an array.
FIELDVALUE
Returns the field data from a Stocks or Geography linked data type.
ISOMITTED
Returns the value True or False depending whether the value in a LAMBDA is missing.
LAMBDA
Returns the results of a formula added as a named range.
MAKEARRAY
Returns the array calculated by applying a LAMBDA function.
MAP
Returns the array formed by applying a map using a LAMBDA function.
REDUCE
Returns the total value after reducing an array by applying a LAMBDA function.
SCAN
Returns the array after appliying a LAMBDA function to each value and returns an array.
STOCKHISTORY
Returns the historical data about a financial instrument.
VALUETOTEXT
Returns the text from any specified value.

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