Resources > Formula Help
How Do I Use UNIQUE in Excel?
Last Updated: June 2026
Quick Answer
UNIQUE returns a list of distinct values from a range.
=UNIQUE(A2:A100)
Sort Unique Values
=SORT(UNIQUE(A2:A100))
Return Values That Appear Exactly Once
=UNIQUE(A2:A100,,TRUE)
The third argument set to TRUE returns values that occur only once.
Use UNIQUE for Reports
UNIQUE is useful for creating dynamic lists of customers, regions, departments, categories, or statuses.
