Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Compare to Columns of Text Data (2000)

    Hi, I want to compare two columns of last names, looking for equality. For example, if there is a Jones in A1 does it match the Jones in G11. One list is longer than the other so, it is not possible to sort then use =a1=g1. I have tried the formula =a1=$g$1:$g$50 and it only works on the first cell.

    Any ideas?

    Thanks.

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

    Re: Compare to Columns of Text Data (2000)

    Try this:

    =COUNTIF($G$1:$G$50,A1)>0

    and fill down as far as needed. The COUNTIF function counts the number of matches for the value of A1 in the range G1:G50; if this count is greater then 0, there is a match.

  3. #3
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compare to Columns of Text Data (2000)

    Hans, worked perfect.

    Thanks.

Posting Permissions

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