UNIQUE

Returns the array of unique values from a range or array of values.

Sintaxis

UNIQUE(Array, [By col], [Uniqueness])

Array: the range or array from which to return unique values.

By col: (optional) a logical value that indicates how to compare data: TRUE - compares data horizontally for a match of all cells in each column, across all columns. FALSE or omitted (default) - compares data vertically, for a match of all cells of each row, across all rows.

Uniqueness: (optional) A logical value that defines which values are considered unique. TRUE returns values that occur only once. The default is FALSE or omitted, which returns all distinct values in the range or array.

The UNIQUE function must be entered as an array formula.

Exemplos

Given the data table below, the examples returns unique occurrences of grades and age.

 A B C D E Nome Grau Edá Distancia Pesu Adelín 3 9 150 40 Bríxida 4 10 1000 42 Caitanu 3 10 300 51 Dubardu 5 11 1200 48 Evanxelina 2 8 650 33 Florián 2 7 300 42 Grabiela 1 7 200 36 Hugu 3 9 1200 44 Imelda 2 8 1000 42

Exemplu 1

{=UNIQUE(B1:C10,FALSE(),FALSE())} returns the array below. The grades and ages of the rows with name Andy and Harry are returned only once. The same for rows with name Eva and Irene.

 Grau Edá 3 9 4 10 3 10 5 11 2 8 2 7 1 7

Exemplu 2

{=UNIQUE(B1:C10,FALSE(),TRUE())}, with Uniqueness as TRUE. Returns the array below with the rows of Andy, Harry, Eva and Irene omitted because their combined grades and ages are not unique.

 Grau Edá 4 10 3 10 5 11 2 7 1 7

Información téunica

Esta función ta disponible dende la versión 24.8 de LibreOffice.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.UNIQUE