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 🇧🇷 🇺🇸 🇫🇷

Twitter
LinkedIn


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

Sources:

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 https://github.com/campelo/documentation and open a new pull request with your changes.

Discussion (0)