Dynamic Array Functions
All these functions were added in Microsoft 365.
| CHOOSECOLS | (2022) The array with just a specific number of columns. |
| CHOOSEROWS | (2022) The array with just a specifiic number of rows. |
| DROP | (2022) The array without certain rows or columns. |
| EXPAND | (2022) The array expanded or padded to specific dimensions. |
| FILTER | (2021) The array after filtering data that satisfies multiple conditions. |
| GROUPBY | (2023) The grouping of your data along one axis and aggregates the associated values. |
| HSTACK | (2022) The array after putting multiple arrays next to each other. |
| PIVOTBY | (2023) The grouping of your data along two axis and aggregates the associated values. |
| SORT | (2021) The array of data that has been sorted by one column. |
| SORTBY | (2021) The array of data that has been sorted based on multiple columns. |
| TAKE | (2022) The intersection of specific rows and columns in an array. |
| TOCOL | (2022) The array transformed into a single column. |
| TOROW | (2022) The array transformed into a single row. |
| TRIMRANGE | (2024) The array after excluding all empty rows and/or columns from the outer edges of a range. |
| UNIQUE | (2021) The array of unique values in a list, table or cell range. |
| VSTACK | (2022) The array after putting multiple arrays on top of each other. |
| WRAPCOLS | (2022) The array transformed into multiple columns. |
| WRAPROWS | (2022) The array transformed into multiple rows. |
| CHOOSECOLS (2022) The array with just a specific number of columns. |
| CHOOSEROWS (2022) The array with just a specifiic number of rows. |
| DROP (2022) The array without certain rows or columns. |
| EXPAND (2022) The array expanded or padded to specific dimensions. |
| FILTER (2021) The array after filtering data that satisfies multiple conditions. |
| GROUPBY (2023) The grouping of your data along one axis and aggregates the associated values. |
| HSTACK (2022) The array after putting multiple arrays next to each other. |
| PIVOTBY (2023) The grouping of your data along two axis and aggregates the associated values. |
| SORT (2021) The array of data that has been sorted by one column. |
| SORTBY (2021) The array of data that has been sorted based on multiple columns. |
| TAKE (2022) The intersection of specific rows and columns in an array. |
| TOCOL (2022) The array transformed into a single column. |
| TOROW (2022) The array transformed into a single row. |
| TRIMRANGE (2024) The array after excluding all empty rows and/or columns from the outer edges of a range. |
| UNIQUE (2021) The array of unique values in a list, table or cell range. |
| VSTACK (2022) The array after putting multiple arrays on top of each other. |
| WRAPCOLS (2022) The array transformed into multiple columns. |
| WRAPROWS (2022) The array transformed into multiple rows. |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext