← Back to level 2
Level 2Level 2
UNIQUE
Returns distinct values from a list automatically.
Syntax
=UNIQUE(array, [by_col], [exactly_once])Step-by-step explanation
- 1Select the list you want to deduplicate.
- 2Let Excel spill the results into empty cells.
- 3Combine with SORT or FILTER for live lists.
Common mistakes
Blocking the spill area
Expecting it to work in older Excel versions
Not matching ranges correctly
Example table
A quick scenario to connect the syntax to the result.
| North |
| North |
| West |
Formula
=UNIQUE(A1:A3)
Result
North, West
Practice area
Extract unique regions from the list.
Match against the syntax block above.