Home/Formulas/Array/UNIQUE
Arrayeasy

UNIQUE()

Returns unique rows in the provided source range, discarding duplicates.

Syntax
fx
=UNIQUE(range)
Try it
F2
→
Acme Co, Globex, Initech, Umbrella
Sample data · sales.csv
ABCD
1CompanyRegionQuarterRevenue
2Acme CoWestQ118,400
3Acme CoWestQ222,100
4Acme CoWestQ331,700
5Acme CoWestQ448,200
6GlobexEastQ114,200
7GlobexEastQ219,800
8GlobexEastQ323,400

Common pitfalls

  • Compares whole rows when given a multi-column range. Two rows differing only in trailing whitespace are considered different: pre-TRIM if needed.
  • Doesn't sort the output: UNIQUE preserves first-appearance order. Wrap in SORT if you need alphabetic order.
  • Case-sensitive. "abc" and "ABC" are kept as separate entries.
Related formulas
FILTER()
Returns a filtered version of the source range, returning only rows or columns which meet the conditions.
SORT()
Sorts the rows of a range by values in one or more columns.
Used by
FILTER()
Returns a filtered version of the source range, returning only rows or columns which meet the conditions.
More Array formulas →Keyboard shortcuts for Sheets →