Cómo funciona.
UNICOS es una función fundamental de Excel. Devuelve una lista con los valores únicos de un rango, eliminando duplicados al instante. Permite automatizar hojas de cálculo, simplificar fórmulas complejas y analizar datos con total precisión en Microsoft Excel y Google Sheets.
💡 En palabras sencillas.
Looks at a list with duplicate entries and returns a clean list containing only one copy of each item.
"Think of this like sorting cards. If you have five duplicate red aces, it keeps only one copy and throws the rest away."
Sintaxis.
Notación Estándar de Excel=UNICOS(matriz; [por_col]; [exactamente_una_vez])Argumentos.
A continuación se detallan todos los parámetros aceptados por esta función.
The range or array to extract unique values from.
Ejemplo:A2:A6FALSE = Compare rows (default), TRUE = Compare columns.
Valor por defecto: FALSEFALSE = Return all unique values (default), TRUE = Return only values that appear exactly once in the list.
Valor por defecto: FALSEEjemplo práctico.
Caso de Uso Paso a PasoExtract Sales Categories
Extract a clean list of unique product departments that recorded sales.
| Sale Department | Amount | Unique list | ||
|---|---|---|---|---|
| Electronics | 120 | — | — | — |
| Home Decor | 45 | — | — | — |
| Electronics | 250 | — | — | — |
=UNIQUE(A2:A6)Evaluates UNIQUE over the sample table cells, placing the verified output in cell C2:C6.
Generador de fórmula.
Abrir Asistente CompletoPersonaliza los campos de argumento a continuación para generar una fórmula lista para copiar y pegar en tu hoja de cálculo.
=UNICOS()Comportamiento del resultado.
Returns "Calculated output" based on sample evaluation criteria and active cell references.
Buenas Prácticas
- Nest UNIQUE inside SORT to get a alphabetically or numerically sorted list of unique values (e.g. `=SORT(UNIQUE(A2:A20))`).
- You can retrieve unique rows across multiple columns (like unique First/Last name combos).
Errores Frecuentes
- Requires Excel 365 or 2021+. Returns #SPILL! if any cell in the output range is already occupied.
Compatibilidad de plataforma y versiones.
Matriz verificada con base en los motores de cálculo oficiales de Microsoft Excel y Google Sheets.
In Excel 2019, use Data > Remove Duplicates or an Advanced Filter with "Unique records only".
Introduced in Excel 365 and Excel 2021. Not available in Excel 2019.
Native Google Sheets function for deduplicating ranges with automatic multi-cell spilling.
Preguntas frecuentes.
Dudas TécnicasHow does UNIQUE handle empty or blank cells?↓
By default, UNIQUE will return a 0 for blank cells in the source range. You can nest FILTER inside UNIQUE to exclude empty cells before deduplicating.
Can UNIQUE extract items that appear exactly once?↓
Yes. Setting the third argument exactly_once to TRUE will filter out any items that appear more than once, leaving only distinct unique entries.