UNICOS

Devuelve una matriz de valores únicos a partir de un intervalo o una matriz de valores.

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.

Ejemplos

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

	A	B	C	D	E
1	Nombre	Grado	Edad	Distancia	Peso
2	Andrés	3	9	150	40
3	Beatriz	4	10	1000	42
4	Carlos	3	10	300	51
5	Daniel	5	11	1200	48
6	Eva	2	8	650	33
7	Franco	2	7	300	42
8	Greta	1	7	200	36
9	Henrique	3	9	1200	44
10	Irene	2	8	1000	42
11

Ejemplo 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.

Grado	Edad
3	9
4	10
3	10
5	11
2	8
2	7
1	7

Ejemplo 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.

Grado	Edad
4	10
3	10
5	11
2	7
1	7

Información técnica

Esta función está disponible desde la versión 24.8 de LibreOffice.

Esta función no forma parte de la norma Formato de Documentos Abierto para Aplicaciones de Oficina (OpenDocument), versión 1.3. Parte 4: formato de fórmulas recalculadas (OpenFormula). El espacio de nombres es

COM.MICROSOFT.UNIQUE

UNIQUE wiki page.