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:
Table of Contents
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
![UNIQUE Formula in Excel | MyExcelOnline UNIQUE Formula in Excel | MyExcelOnline](https://www.myexcelonline.com/wp-content/uploads/2024/07/Bryan-Hong-2-150x150.jpg)
Bryan
Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).
He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.