FUNCTION CATALOGUE / LOOKUP & REFERENCE
UNIQUE Excel function
Returns distinct values.
Correct sentence to use
Return the unique values in [range].
Modify this query in PlainFormula →Example formula
=UNIQUE(A2:A100)
Returns distinct values from a range.
Syntax
UNIQUE(array, [by_col], [exactly_once])
Argument signature: array, [by_col], [exactly_once]
Availability note
Available in supported Microsoft 365 / newer Excel versions; verify the exact release and platform.