What does it do?

Gets the unique values of a list

Formula breakdown:


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:

UNIQUE Formula in Excel | MyExcelOnline


STEP 1: We need to enter the UNIQUE function in a blank cell:


UNIQUE Formula in Excel


STEP 2: The UNIQUE arguments:


What is the data to be cleared of duplicate values?

Select the cells containing the names, do not include the headers:


UNIQUE Formula in Excel


Now the duplicate names are all gone!

UNIQUE Formula in Excel


How to Use the UNIQUE Formula in Excel




UNIQUE Formula in Excel | MyExcelOnline

If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook

Tweet about this on Twitter

Share on LinkedIn