Google Sheets Function: UNIQUE

The UNIQUE function returns the unique rows from the provided range excluding duplicates.

Usage:

=UNIQUE(range)


Example of use

The UNIQUE function should return in the green table all the unique rows from the blue table:

google sheets function unique

Enter the cell range from the blue table into the UNIQUE function to get a table with unique rows:

=UNIQUE(A2:B14)
google sheets function unique rows table

Note that the UNIQUE function can also be used to remove duplicates from a range with a single column:

google sheets function unique cells duplicates