Skip to content
Google Sheets

UNIQUE function in Google Sheets

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.

=UNIQUE(range, by_column, exactly_once)

UNIQUE syntax and parameters

Three arguments, three required.

  • rangerangeRequired
  • by_columnanyRequired
  • exactly_onceanyRequired

UNIQUE examples

Formulas you'll actually reuse.

  1. The distinct customer list from an orders sheet, in first-seen order:

    =UNIQUE(A2:A200)

  2. Customers who ordered exactly once (exactly_once = TRUE):

    =UNIQUE(A2:A200, FALSE, TRUE)

UNIQUE in Excel

Same name — your formula ports as-is.

Try UNIQUE in the playground

Edit the example — nothing to install.

Preloaded with the UNIQUE formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.