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.

ARRAYTOTEXT(2021) Returns the contents of an array or cell range converted into text.
BYCOL(2021) Returns the results from applying a LAMBDA function to each column in an array.
BYROW(2021) Returns the results from applying a LAMBDA function to each row in an array.
CHOOSECOLS(2022) Returns the specified columns from an array.
CHOOSEROWS(2022) Returns the specified rows from an array.
DROP(2022) Returns the subset of continuous rows or columns from array start or end.
EXPAND(2022) Returns the array expanded or padded to specific dimensions.
FIELDVALUE(2020) Returns the field data from a Stocks or Geography linked data type.
HSTACK(2022) Returns the horizontal array formed by appending the array arguments.
ISOMITTED(2021) Returns the value True or False depending whether the value in a LAMBDA is missing.
LAMBDA(2020) Returns the results of a formula added as a named range.
MAKEARRAY(2021) Returns the array calculated by applying a LAMBDA function.
MAP(2021) Returns the array formed by applying a map using a LAMBDA function.
REDUCE(2021) Returns the total value after reducing an array by applying a LAMBDA function.
SCAN(2021) Returns the array after applying a LAMBDA function to each value and returns an array.
STOCKHISTORY(2020) Returns the historical data about a financial instrument.
TAKE(2022) Returns the subset of contiguous rows or columns from the start or end of an array.
TEXTAFTER(2022) Returns the characters from the end of a text string after a delimiter.
TEXTBEFORE(2022) Returns the characters from the start of a text string before a delimiter.
TEXTSPLIT(2022) Returns the text string split into multiple columns using delimiters.
TOCOL(2022) Returns the column vector containing all the items in an array.
TOROW(2022) Returns the row vector containing all the items in an array.
VALUETOTEXT(2021) Returns the text from any specified value.
VSTACK(2022) Returns the vertical array formed by appending the array arguments.
WRAPCOLS(2022) Returns the column vector converted into a 2-dimensional array by column.
WRAPROWS(2022) Returns the row vector converted into a 2-dimensional array by row.
ARRAYTOTEXT
(2021) Returns the contents of an array or cell range converted into text.
BYCOL
(2021) Returns the results from applying a LAMBDA function to each column in an array.
BYROW
(2021) Returns the results from applying a LAMBDA function to each row in an array.
CHOOSECOLS
(2022) Returns the specified columns from an array.
CHOOSEROWS
(2022) Returns the specified rows from an array.
DROP
(2022) Returns the subset of continuous rows or columns from array start or end.
EXPAND
(2022) Returns the array expanded or padded to specific dimensions.
FIELDVALUE
(2020) Returns the field data from a Stocks or Geography linked data type.
HSTACK
(2022) Returns the horizontal array formed by appending the array arguments.
ISOMITTED
(2021) Returns the value True or False depending whether the value in a LAMBDA is missing.
LAMBDA
(2020) Returns the results of a formula added as a named range.
MAKEARRAY
(2021) Returns the array calculated by applying a LAMBDA function.
MAP
(2021) Returns the array formed by applying a map using a LAMBDA function.
REDUCE
(2021) Returns the total value after reducing an array by applying a LAMBDA function.
SCAN
(2021) Returns the array after applying a LAMBDA function to each value and returns an array.
STOCKHISTORY
(2020) Returns the historical data about a financial instrument.
TAKE
(2022) Returns the subset of contiguous rows or columns from the start or end of an array.
TEXTAFTER
(2022) Returns the characters from the end of a text string after a delimiter.
TEXTBEFORE
(2022) Returns the characters from the start of a text string before a delimiter.
TEXTSPLIT
(2022) Returns the text string split into multiple columns using delimiters.
TOCOL
(2022) Returns the column vector containing all the items in an array.
TOROW
(2022) Returns the row vector containing all the items in an array.
VALUETOTEXT
(2021) Returns the text from any specified value.
VSTACK
(2022) Returns the vertical array formed by appending the array arguments.
WRAPCOLS
(2022) Returns the column vector converted into a 2-dimensional array by column.
WRAPROWS
(2022) Returns the row vector converted into a 2-dimensional array by row.

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