UNIQUE Formula in Excel

 

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