How do I use UNIQUE in Excel?
Use UNIQUE when you want to return unique values only. Enter Target range, Compare by column, Exactly once only in that order, then add optional arguments when needed.
Excel Function
UNIQUE
Returns unique values from a range.
UNIQUE(array, [by_col], [exactly_once])Arguments
array
RequiredSpecify a reference range. You can drag or click start/end cells.
by_col
OptionalSpecify TRUE or FALSE.
exactly_once
OptionalSpecify TRUE or FALSE.
Practice Preview
Use UNIQUE to return the distinct values from Category in column B. You can set ranges by dragging from the start cell to the end cell in the same argument field.
Example Table
| # | AProduct ID | BCategory | CProduct Name | DSales |
|---|---|---|---|---|
| 2 | P001 | Food | Apple | 1200 |
| 3 | P002 | Food | Banana | 980 |
| 4 | P003 | Stationery | Notebook | 450 |
| 5 | P004 | Stationery | Pen | 300 |
| 6 | P005 | Food | Grapes | 1500 |
| 7 | P006 | Stationery | Ruler | 250 |
| 8 |
How to Use (Formula)
=UNIQUE(B2:B7, FALSE, FALSE)Result
Food, Stationery
Practice This Function
UNIQUE FAQ
Where can I practice UNIQUE?
Use the "Start Function Practice" button to jump straight into UNIQUE drills.
What arguments does UNIQUE use?
The main arguments are Target range, Compare by column, Exactly once only. Start with the required ones, then add optional arguments if needed.