+ Reply to Thread
Results 1 to 4 of 4

How can you identify duplicate entries in a singe column?

  1. #1
    Melissa
    Guest

    How can you identify duplicate entries in a singe column?

    How can you identify duplicate entries in a singe column? Can you identify
    duplicate data in 2 columns where each column in on a different worksheet?

  2. #2
    Registered User
    Join Date
    10-05-2005
    Posts
    34

    I can answer the first question...

    You will need to input the following formula in as a conditional format.

    Menu -> Format -> Conditional Format -> [Change drop down to] Formula is

    =COUNTIF($B:$B,$B1)>1

    That should work...

    JustMe.

  3. #3
    Forum Contributor
    Join Date
    12-14-2005
    Posts
    176
    If the values are in Column A, Sort the column. Then enter a Title for the the column A in Cell A1 or just insert a row and leave it "Blank". Then in Column B you can enter the following formula. =IF(A2=A1,"Duplicate","Non Duplicate") and then copy down - this will give you a visual representation of any duplicate values. You can enter any value you want for Duplicate and Non Duplicate.
    Second part of your Question:
    Sheet 1 in Column B add Sheet1 for each value
    Sheet 2 in Column B add Sheet2 for each value
    Copy Columns A and B from Sheet 1 and Sheet 2 - paste them into Sheet 3
    and then do the same formula as above in Column C - This will show you where the duplicates are.

  4. #4
    Melissa
    Guest

    Re: How can you identify duplicate entries in a singe column?

    Thanks! Worked like a charm!!
    I appreciate your help!
    Melissa

    "JustMe602" wrote:

    >
    > You will need to input the following formula in as a conditional
    > format.
    >
    > Menu -> Format -> Conditional Format -> [Change drop down to] Formula
    > is
    >
    > =COUNTIF($B:$B,$B1)>1
    >
    > That should work...
    >
    > JustMe.
    >
    >
    > --
    > JustMe602
    > ------------------------------------------------------------------------
    > JustMe602's Profile: http://www.excelforum.com/member.php...o&userid=27854
    > View this thread: http://www.excelforum.com/showthread...hreadid=498031
    >
    >


+ 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