How to identify and remove duplicates in Excel

In this post, I’m going to show you  how to locate and remove duplicates

Use Conditional Formatting to identify duplicates and then remove them.

1. Highlight the area you want to apply conditional formatting to (don’t forget to use Ctrl and Shift and Arrow Down to quickly highlight – and if you haven’t done so already – you can get lots of other shortcuts in the sheet you get when you sign up 🙂 )
2. Home – Conditional Formatting – Highlight Cells Rules – Duplicate Values
3. Choose whether you want duplicate or unique values – and then choose your formatting
4. You can then use Data | Filter to identify your duplicates
5. Use Data | Remove Duplicates to remove your duplicates
6. Then check again that they are gone.

You can download the file I used here.

I used data from fakenamegenerator.com