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