|
CHOOSE
|
Returns a parameter with the given numeric position.
|
|
FILTER
|
Filters an array using a logical array.
|
|
INDEX
|
Returns the array element at the given position.
|
|
LET
|
Assigns names to values and allows these values to be used in
subsequent calculations.
|
|
MAP
|
Transforms all array elements using a formula fragment and returns an
array with the results.
|
|
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
|
Looks up a value in the second array which corresponds to a value in
the first array matching the first parameter.
|
|
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.
|