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