UNIQUE function in Excel
UNIQUE returns the unique values in a range (spills).
Syntax
=UNIQUE(array)
| Argument | Required? | What it is |
|---|---|---|
| array | Required | The range or array to work on. |
Practise UNIQUE in a live spreadsheet
Type the formula yourself and get it graded instantly, no Excel needed.