UNIQUE
Returns a list with the duplicates removed.
How it’s written
UNIQUE(range)Example
| A | B | C | |
|---|---|---|---|
| 1 | Region | Rep | Sales |
| 2 | North | Amara | 400 |
| 3 | South | Ben | 250 |
| 4 | North | Chloe | 150 |
| 5 | West | Dev | 700 |
=INDEX(UNIQUE(A2:A5),3)Result: West
The list of regions is North, South, West, so the third is West. On its own, UNIQUE spills the whole list.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Results spill downward, so keep the cells below empty.
Practice it properly
UNIQUE and SORT gives you real tasks, with your formulas tested on data you haven’t seen.