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.

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

Top comments (0)

AWS Security LIVE!

Tune in for AWS Security LIVE!

Join AWS Security LIVE! for expert insights and actionable tips to protect your organization and keep security teams prepared.

Learn More

👋 Kindness is contagious

Explore a sea of insights with this enlightening post, highly esteemed within the nurturing DEV Community. Coders of all stripes are invited to participate and contribute to our shared knowledge.

Expressing gratitude with a simple "thank you" can make a big impact. Leave your thanks in the comments!

On DEV, exchanging ideas smooths our way and strengthens our community bonds. Found this useful? A quick note of thanks to the author can mean a lot.

Okay