Syntax
Distinct(Table, Formula)Examples
=Distinct(["Red", "Blue", "Red"], Value)Red, Blue
Maker notes
- The result is a single-column table whose column is named Value.
Distinct
Returns the unique values of a formula across a table.
Returns the unique values of a formula across a table.
Distinct(Table, Formula)=Distinct(["Red", "Blue", "Red"], Value)Red, Blue