Unique

Description of formula:
Returns distinct values from specified table (omits duplicates). The parameters can be passed as single values, arrays or cell ranges. All values should be of the same type.
For example formula “=unique(4, 1, 1, 2, 4, 3, 1)” returns an array with values: 4, 1, 2, 3.

Remark: After dragging a field from the "Data" tab, the default lookup formula no longer includes unique(). This prevents costly count queries from being executed, improving performance for large tables. If unique values are required, unique() must be added manually.

Syntax:
unique(element, ...)

Parameters:

element

(type: any) (multiple parameter) Values in array

Returned type:

array of values of any type

Examples:

=array(unique('1', '2', '2', '2', '5', '5'))
=unique(A1:A12) 
=unique(section1.A)
=array(unique('one','three','one','two'))