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:

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

=UNIQUE(A2:B14)

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