Excel UNIQUE Function: How to Use It, with Examples
Turkish: BENZERSİZ

Removes duplicates from a range and returns the list of unique values (spills into the cells below).

UNIQUE syntax

=UNIQUE(array)

In Turkish Excel: =BENZERSİZ(dizi)

ArgumentDescription
arrayThe range to get unique values from.

UNIQUE examples

Sample table:

ABCD
1ProductRegionQuantityPrice
2PenAnkara125
3Notebookİzmir820
4EraserAnkara302
5NotebookAnkara520
6Penİzmir75
=ROWS(UNIQUE(A2:A6))
Result: 3

How many different products are there? (UNIQUE + ROWS)

Results were calculated in real Excel.

Tips for UNIQUE

  • Available in Excel 2021 and Microsoft 365.

Related functions

More formula guides

More tools

About UNIQUE Function

Removes duplicates from a range and returns the list of unique values (spills into the cells below).

Turkish function names were taken directly from Turkish Excel, and the example results on formula pages were calculated in real Excel. Everything runs in your browser; your data is never uploaded.

How to use UNIQUE Function

  1. Type the formulaStart typing =UNIQUE( in a cell; Excel shows the arguments.
  2. Fill in the argumentsSeparate them with commas (semicolons in Turkish Excel).
  3. Press EnterCheck the result; you can also try it in the tester below.

Frequently asked questions

What is UNIQUE in Turkish Excel?

In Turkish Excel, UNIQUE is called BENZERSİZ. Turkish Excel also separates arguments with semicolons (;) instead of commas.

Which Excel versions have UNIQUE?

UNIQUE is available in Excel 2021 and Microsoft 365.