Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Find Non Duplicates (Office 2000)

    Hi,
    I have a list in column A of 680 rows. I have a similar list in Column B but only 640 rows. I need to find the 40 items from column A that are not duplicated in column B.
    What formula would I use?

    Thanks
    Louise

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Find Non Duplicates (Office 2000)

    Hi Louise

    Have a look at this <post:=340,261>post 340,261</post:> and the ensuing conversation to give you some ideas
    Jerry

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Find Non Duplicates (Office 2000)

    Let's assume the data are in A1:A680 and B1:B640.
    If you want to create a column with formulas, try something like
    <code>
    =IF(COUNTIF($B$1:$B$640,A1)=0,"X","")
    </code>
    in C1 and fill down to C680. Column C will contain an "X" if the value in column A does not occur in column B.

    You could also apply conditional formatting to A1:A680 to highlight the non-duplicated values, with Formula Is option and the following formula:
    <code>
    =COUNTIF($B$1:$B$4,A1)=0</code>

  4. #4
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find Non Duplicates (Office 2000)

    Hi Jerry,

    Thanks so much for finding that. I did a search but must not have entered the correct terms.
    Will give it a try!

    Thanks again.
    Louise

  5. #5
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find Non Duplicates (Office 2000)

    Hi Hans!

    Thank you very much! Will give it a try.

    Have a great day!
    Louise

  6. #6
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find Non Duplicates (Office 2000)

    Hi Hans,
    That worked beautifully. Thank you very much!
    Louise

Posting Permissions

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