Array

Work on whole ranges at once and return multiple values.

Function	What it does
ARRAY_CONSTRAIN	Truncates a range to at most the given rows and columns.
ARRAYFORMULA	Evaluates an expression across a range (this engine already spills, so it is a pass-through for sheets compatibility).
ARRAYTOTEXT	Converts array to text representation.
BYCOL	Applies lambda to each column of array.
BYROW	Applies lambda to each row of array.
CHOOSECOLS	Returns the specified columns from an array.
CHOOSEROWS	Returns the specified rows from an array.
DROP	Removes rows or columns from the start or end of an array.
EXPAND	Pads an array to a given size with a fill value.
FILTER	Returns the rows or columns of a range that meet a condition.
FLATTEN	Collapses one or more ranges into a single column.
HSTACK	Joins arrays side by side into one array.
ISOMITTED	Checks if lambda argument is omitted.
LAMBDA	Creates a custom reusable function.
LET	Assigns names to values in a formula.
MAKEARRAY	Creates array from lambda over indices.
MAP	Maps lambda over array values.
RANDARRAY	Returns an array of random numbers.
REDUCE	Reduces array to value with lambda.
SCAN	Scans array with lambda keeping intermediates.
SEQUENCE	Generates a sequence of numbers as an array.
SORT	Sorts the contents of a range or array.
SORTBY	Sorts a range or array by values in a corresponding range.
SORTN	The first n rows of a range after sorting.
TAKE	Returns rows or columns from the start or end of an array.
TOCOL	Returns an array as a single column.
TOROW	Returns an array as a single row.
TRANSPOSE	Flips the orientation of a range or array.
TRIMRANGE	Trims empty rows and columns from the edges of a range.
UNIQUE	Returns the distinct values from a range or array.
VSTACK	Stacks arrays on top of each other into one array.
WRAPCOLS	Wraps a row or column into a 2-D array by columns.
WRAPROWS	Wraps a row or column into a 2-D array by rows.