UNIQUE
Returns a list of unique values in a list or range.
Lookup & ReferenceDynamic Arrays & LAMBDALookup & Matching EssentialsModern Excel Functions
What it does
Returns a list of unique values from a range or array (dynamic array).
Syntax
UNIQUE(array, [by_col], [exactly_once])
Arguments
array(range|array) — Range to return uniques from.
Examples
Unique categories
Return unique categories from A2:A7.
FORMULA
=UNIQUE(A2:A7)
RESULT
[spills]
SAMPLE DATA
| A | |
|---|---|
| 1 | Category |
| 2 | Food |
| 3 | Travel |
| 4 | Food |
| 5 | Other |
| 6 | Food |
| 7 | Travel |