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.
COPILOT	The response based on your referenced data using an AI model.
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 summary table after grouping and aggregating by row.
PIVOTBY	The summary table after grouping and aggregating by row and column.
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.
COPILOT The response based on your referenced data using an AI model.
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 summary table after grouping and aggregating by row.
PIVOTBY The summary table after grouping and aggregating by row and column.
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.