The UNIQUE function returns each single value contained in a column (no duplicate).
- Write the UNIQUE function in a cell
The UNIQUE function is available only for Excel Microsoft 365 or Excel Online
- Select your range of cells
No complex technique, you just select your list of values
- [optional] Return only single values
This function can also return only the single value
=UNIQUE(Range of cells,,Option for single value)
Extract without duplicates manually
In Excel, it has always been possible to extract without duplicated values with the menu Data > Remove Duplicates in the ribbon.
However, if the data is refreshed, you must redo the manipulation again and again and again 😒😕
How to use the UNIQUE function
The UNIQUE function is so simple to use 😀
- Just write the UNIQUE in a cell
- And select the column containing the values with duplicates.
Immediately, the function returns a list of values corresponding to the values without duplicates.
And this function works also when you select more than 1 column.
- Write the name of the function in a cell
- Select the 2 columns
As you can see, the result takes in consideration the content of the 2 columns 😯👍
What happens when your data are refreshed
When your data are inside a Table, the reference is dynamic. That means if you add, or delete a value in the initial column, the result is updated automatically 😀👍
Extract single items
UNIQUE can also extract the values present only once in a list of data. Here, you must fill in the third argument of the function.
The UNIQUE function in Excel efficiently extracts distinct values from a range, streamlining data analysis and reducing duplication.
It simplifies decision-making and enhances insights by providing a consolidated view of unique elements within the dataset, optimizing workflow and enhancing overall productivity.