+ Reply to Thread
Results 1 to 4 of 4

Finding Duplicates

  1. #1
    Registered User
    Join Date
    10-05-2011
    Location
    Guam, USA
    MS-Off Ver
    Excel 2003
    Posts
    11

    Finding Duplicates

    Hi all,

    What is the easiest way to find if there are any duplicates in a column?

    Thank you!

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Finding Duplicates

    Conditional Formatting > Highlight cells rules > duplicated values

  3. #3
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Finding Duplicates

    Many ways to skin that cat:

    Please Login or Register  to view this content.
    in column B and drag down.

    abousetta
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  4. #4
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Finding Duplicates

    Another approach... if you only want to highlight the duplicates and leave the original unique entry you can use something like this:

    Please Login or Register  to view this content.
    in cell B1 and drag down.

    abousetta

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1