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. |
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. |
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. |
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. |
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. |
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext