UNIQUE function

Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range.

Parts of a UNIQUE function

UNIQUE(range, by_column, exactly_once)

Part Description

range

The data to filter by unique entries.

by_column

Whether to filter the data by columns or by rows. By default, this is false.

exactly_once

Whether to return only entries with no duplicates. By default, this is false.

Notes 

  • If rows are returned which appear to be duplicates, ensure that cells including text do not have differing hidden text such as trailing spaces.
  • Ensure that numeric values are formatted in the same way - percentages as percentages, currency values as currency values, etc.

Examples 

  Color 1 Color 2 Color 3
  Red Yellow Red
  Blue Magenta Blue
  Red Yellow Red
  Green White Green
       
       
Formula =UNIQUE(B2:D5)
Output Red Yellow Red
  Blue Magenta Blue
  Green White Green
       
       
Formula =UNIQUE(B2:D5, TRUE)
Output

Red

Yellow  
  Blue Magenta  
  Red Yellow  
  Green White  
       
       
Formula =UNIQUE(B2:D5, TRUE)
Output Blue Magenta Blue
  Green White Green

Related functions 

Was this helpful?
How can we improve it?