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 array with just a specific number of columns.
CHOOSEROWS(2022) Returns the array with just a specific number of rows.
DROP(2022) Returns the array without certain rows or columns.
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.
GROUPBY(2023) Returns the grouping of your data along one axis and aggregates the associated values.
HSTACK(2022) Returns the array after combining two arrays horizontally in sequence.
IMAGE(2022) Returns the image from a web URL.
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.
PIVOTBY(2023) Returns the grouping of your data along two axis and aggregates the associated values.
PY(2023) Returns the value or object after running code in a Python Editor.
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 intersection of specific rows and columns in 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 array transformed into a single column.
TOROW(2022) Returns the array transformed into a single row.
VALUETOTEXT(2021) Returns the text from any specified value.
VSTACK(2022) Returns the array after combining two arrays vertically in sequence.
WRAPCOLS(2022) Returns the array transformed into multiple columns.
WRAPROWS(2022) Returns array transformed into multiple rows.
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 array with just a specific number of columns.
CHOOSEROWS
(2022) Returns the array with just a specific number of rows.
DROP
(2022) Returns the array without certain rows or columns.
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.
GROUPBY
(2023) Returns the grouping of your data along one axis and aggregates the associated values.
HSTACK
(2022) Returns the array after combining two arrays horizontally in sequence.
IMAGE
(2022) Returns the image from a web URL.
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.
PIVOTBY
(2023) Returns the grouping of your data along two axis and aggregates the associated values.
PY
(2023) Returns the value or object after running code in a Python Editor.
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 intersection of specific rows and columns in 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 array transformed into a single column.
TOROW
(2022) Returns the array transformed into a single row.
VALUETOTEXT
(2021) Returns the text from any specified value.
VSTACK
(2022) Returns the array after combining two arrays vertically in sequence.
WRAPCOLS
(2022) Returns the array transformed into multiple columns.
WRAPROWS
(2022) Returns array transformed into multiple rows.

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