How can I  identify duplicate data entries?

Posted on 2011-05-05
Last Modified: 2012-05-11
Dear Experts,

I have a database with duplicate entries.  Can you help me identify and tag those entries.  See attached sample worksheet.  I want an X in column AA for each entry that is duplicated.  (Reference formula in cell H73 that counts my non-duplicate entries <thanks to barryhoudini>.)

Question by:garyrobbins
    LVL 50

    Accepted Solution

    Hello Gary, try this formula in AA8 copied down


    regards, barry

    Author Closing Comment

    Thanks, Barry.  This was a huge help.

    So, how did you become so knowledgeable about excel programming?


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now