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.
Syntax:
unique(element, ...)
Parameters:
element
(type: any) (multiple parameter) Values in array
Returned type:
array of values of any type
Examples:
=unique(array(1, 2, 2, 2, 5, 5))
=unique(array(‘one’, ‘three’, ‘one’, ‘two’))
=unique(A1:A12)
=unique(section1.A)
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk