The result is a dynamic array of unique values.
If this array is the final result (i.e.
The UNIQUE function takes three arguments:array,by_col, andexactly_once.
The first argument,array, is thearrayorrangefrom which to extract unique values.
This is the only required argument.
The second argument,by_col, controls whether UNIQUE will extract unique values by rows or by columns.
By default, UNIQUE will extract unique values in rows.
To force UNIQUE to extract unique values by columns, setby_colto TRUE or 1.
The last argument,exactly_once,sets behavior for values that appear more than once.
Note: the UNIQUE function isnotcase-sensitive.
UNIQUE will treat “APPLE”, “Apple”, and “apple” as the same text.
By default,exactly_onceis FALSE.
The output from FILTER is dynamic.
If source data or criteria change, FILTER will return a new set of results.
Values can be sorted by one or more columns.
SORT returns a dynamic array of results.
The range or array used to sort does not need to appear in results.
RANDARRAY Function
The Excel RANDARRAY function generates an array of random numbers between two values.
The size or the array is specified byrowsandcolumnsarguments.
The generated values can be either decimals or whole numbers.
SEQUENCE Function
The Excel SEQUENCE function generates a list of sequential numbers in an array.
The array can be one dimensional, or two-dimensional, determined byrowsandcolumnsarguments.
