Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2001
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Comparing data in columns (2000 sr-1)

    I have two columns of data with different part numbers in each column. Some are matching part numbers others are not. Is there a way to easily compare each cell against the other to find duplicate part numbers? Each column is about 200 rows deep.

    Thx in advacne

    T-Man

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comparing data in columns (2000 sr-1)

    Use Format|Conditional Formatting. Choose (say) B1 and set the condtion to be equal to A1 - making sure you take out the "$" sign before the "1". Then copy B1, select the entire Column B and choose Edit|Paste Special|Formats. (You may have to tinker slightly if you have Header rows.) HTH
    Gre

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Comparing data in columns (2000 sr-1)

    Hi T-Man,

    Unkamunka's solution works OK if your data is sorted but, if it isn't, try something like:
    =COUNTIF(A$1:A$200,A1)
    as a straight formula in an unused column or:
    =(COUNTIF(A$1:A$200,A1)>1)
    with Conditional Formatting in the data column, copying as proposed by Unkamunka. The advantage of the straight formula is that it tells you exactly how many instances of each record exist.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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