Home › UNIQUE

UNIQUE in every language

Lookup and referenceMicrosoft 365Last verified 2026-11-04

LanguageNameSyntaxLibreOfficeSheets
EnglishUNIQUEUNIQUE(array, [by_col], [exactly_once])——
GermanEINDEUTIGEINDEUTIG(array; [nach_Spalte]; [genau_einmal])EINZIGARTIGUNIQUE
FrenchUNIQUEUNIQUE(tableau; [by_col]; [exactly_once])UNIQUEUNIQUE
SpanishUNIQUEUNIQUE(array; [by_col]; [exactly_once])UNICOSUNIQUE
Portuguese (Brazil)ÚNICOÚNICO(matriz; [por_col]; [exatamente_uma_vez])ÚNICOUNIQUE
DutchUNIEKUNIEK(matrix; [per_kolom]; [exact_eenmaa])UNIEKUNIQUE
ItalianUNICIUNICI(matrice; [by_col]; [exactly_once])UNICIUNIQUE

Names and arguments from Microsoft Support; the LibreOffice and Google Sheets columns are those products' own localized names. Array-constant separators and localized error values are not yet covered.

Translate a formula with UNIQUE