CHOOSE

Returns a given parameter based on its numeric position and the value
of the first parameter.

FILTER

Filters the first array using the second parameter.

INDEX

Returns the array element at the given position.

MAP

Applies the transformation specified by the given formula fragment to
all array elements and returns the resulting array.

MATCH

Returns the position that a given value appears at in the given lookup
array, or returns an #N/A error if the value cannot be found.

REDUCE

Reduces an array of values to a single value using a usersupplied
formula.

REVERSEARRAY

Reverses the given array and returns it.

SORT

Sorts and returns the given array.

SORTBY

Sorts and returns a given array, where the sort order is based on sort
arrays given to this function.

UNIQUE

Returns a version of the given array with all duplicate values removed.

XLOOKUP

Returns the array element in the second array with the same position as
an element in the first array which is equal to a given value.

XMATCH

Returns the position that a given value appears at in the given lookup
array, or returns an #N/A error if the value cannot be found.
