Normally when we have dirty data, we tend to get a lot of duplicates. But in Excel it is very easy to spot the duplicates for your data cleanup!

Here is our sample list of words, you can see it has a lot of duplicates:

How to Find Duplicates in Excel | MyExcelOnline

I explain how you can do this below:

How to Find Duplicates in Excel | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK

STEP 1: Select your list of words / data:

How to Find Duplicates in Excel | MyExcelOnline

 

STEP 2: Go to Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values

How to Find Duplicates in Excel | MyExcelOnline

 

STEP 3: You can select the formatting that you want. For our example, we selected Green Fill with Dark Green Text.

Click OK.

How to Find Duplicates in Excel | MyExcelOnline

 

You will now see the magic happen, all of the duplicate values are now highlighted in your Excel worksheet!

How to Find Duplicates in Excel | MyExcelOnline

 

How to Find Duplicates in Excel | MyExcelOnline

HELPFUL RESOURCES:

Get access to 30+ Microsoft Excel & Office courses for ONLY $1.


Click here to get this limited-time $1 offer!



 

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn