Compare to Columns of Text Data (2000)

Topic

New Reply

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.

Reply | Quote

Replies

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.

Reply | Quote

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.

Reply | Quote

Hans, worked perfect.

Thanks.

Reply | Quote

Hans, worked perfect.

Thanks.

Reply | Quote