Returns a list of unique values from a range or array.
Söz dizimi
UNIQUE(array, [by_col], [exactly_once])Bağımsız değişkenler
arrayzorunlu
The range or array from which to return unique values.
by_colisteğe bağlı
A logical value: FALSE (default) to compare rows, TRUE to compare columns.
exactly_onceisteğe bağlı
A logical value: TRUE returns only items that appear exactly once, FALSE (default) returns all distinct items.
The UNIQUE function extracts a list of distinct values from a specified range or array. It can be configured to compare rows or columns and can optionally filter for values that appear only once.
=UNIQUE(A2:A6)→Unique listReturns a list of all distinct values found in the range A2:A6.
Select a cell
Click the cell where you want the unique list to begin.
Enter the formula
Type =UNIQUE( and select the range of data, then close the parenthesis.
No, UNIQUE treats 'Apple' and 'apple' as the same value.