|
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 user-supplied
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.
|