DEV Community

Cover image for Excel - How to identify duplicated values in a sheet
Flavio Campelo
Flavio Campelo

Posted on

Excel - How to identify duplicated values in a sheet

📮 Contact 🇧🇷 🇺🇸 🇫🇷


If you're looking for duplicated values in a excel sheet, you can find them easily.

Identifying duplicate values

We need to select the columns or cells that have duplicate values and select Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values

Image 1

After that we could right-click on one of the duplicate cells and choose Filter > Filter by Selected Cell's Color

Image 2

All duplicated cells will be filtered

Image 3

To clear conditional filter, choose Conditional Formatting > Clear Rules > Clear Rules from Entire Sheet

Image 4


Duplicate values

Typos or suggestions?

If you've found a typo, a sentence that could be improved or anything else that should be updated on this blog post, you can access it through a git repository and make a pull request. If you feel comfortable with github, instead of posting a comment, please go directly to and open a new pull request with your changes.

Discussion (0)