Data Functions

ARRAYTOTEXT	The contents of an array or cell range converted to text.
CHOOSE	The value in a row (or column) based on an index number.
FILTER	The array after filtering data in a range that satisfies multiple conditions.
HSTACK	The array after putting multiple arrays next to each other.
GETPIVOTDATA	The data obtained from a pivot table.
GROUPBY	The grouping of your data along one axis and aggregates the associated values.
PIVOTBY	The grouping of your data along one axis and aggregates the associated values.
TRIMRANGE	The array after excluding all empty rows and/or columns from the outer edges of a range.
UNIQUE	The array of unique values in a list, table or cell range.
VSTACK	The array after putting multiple arrays on top of each other.

ARRAYTOTEXT The contents of an array or cell range converted to text.
CHOOSE The value in a row (or column) based on an index number.
FILTER The array after filtering data in a range that satisfies multiple conditions.
HSTACK The array after putting multiple arrays next to each other.
GETPIVOTDATA The data obtained from a pivot table.
GROUPBY The grouping of your data along one axis and aggregates the associated values.
PIVOTBY The grouping of your data along one axis and aggregates the associated values.
TRIMRANGE The array after excluding all empty rows and/or columns from the outer edges of a range.
UNIQUE The array of unique values in a list, table or cell range.
VSTACK The array after putting multiple arrays on top of each other.