UNIQUE

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.

Sample usage

UNIQUE(A2:B26)

UNIQUE({1, 2; 3, 4; 5, 6})

Syntax

UNIQUE(range)

  • range – The data to filter by unique entries.

Notes

  • If rows are returned that appear to be duplicates, ensure that cells including text do not have differing hidden text, such as trailing spaces.

  • Ensure that numerical values are formatted in the same way – percentages as percentages, currency values as currency values, etc.

See also

SORT: Sorts the rows of a given array or range by the values in one or more columns.

FILTER: Returns a filtered version of the source range, returning only rows or columns that meet the specified conditions.

Examples

Displays the unique rows specified in a range.

Make a copy

Was this helpful?
How can we improve it?
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
Search Help Centre
true
35
false