UNIQUE Function in Google Sheets

Remove duplicate values from a range using the UNIQUE function.

UNIQUE Function

The UNIQUE function in Google Sheets returns a unique list of values from a specified range.

Syntax

UNIQUE(range)
  • range: The range of cells from which to extract unique values. This is a required parameter.

Examples

  1. Remove Duplicates

Remove duplicates from the range A1:A10:

=UNIQUE(A1:A10)

This will return a list of unique values.

Notes

  • The function only returns the first occurrence of each value.
  • The result is an array, so it will expand to the cells below the formula.
  • FILTER: Filter a range based on specified conditions.
  • SORT: Sort a range based on one or more criteria.