What does it do?
Gets the unique values of a list
Formula breakdown:
=UNIQUE(array)
What it means:
=UNIQUE(data to have duplicates removed)
Want to remove duplicate values from your list? It is definitely possible now with Excel’s UNIQUE Formula. It is a new formula introduced in Office 365 released in 2018!
We have a list of names and we want to remove the duplicates from it. The UNIQUE Formula will make this very quick to do!
I explain how you can do this below:
STEP 1: We need to enter the UNIQUE function in a blank cell:
=UNIQUE(
STEP 2: The UNIQUE arguments:
array
What is the data to be cleared of duplicate values?
Select the cells containing the names, do not include the headers:
=UNIQUE(C9:C14)
Now the duplicate names are all gone!
How to Use the UNIQUE Formula in Excel
