text comparision

[Blah]

I have two columns of names, they include commas seperating last first
etc...how to I do a text comparision function to see if a cell in
column 1 is in the range of cells in column two one cell at a time?


thanks..

 

[MDubbelboer]

to compare if cell b1 is in range a1:a100

=countif($a$1:$a$100,b1)

will return a number greater than 0 if it occurs in that rang

 

[Blah]

to compare if cell b1 is in range a1:a100

=countif($a$1:$a$100,b1)

will return a number greater than 0 if it occurs in that range

Only works with numbers not text....

 

[MDubbelboer]

works fine with text in excel 2003

 

[Blah]

works fine with text in excel 2003

using =COUNTIF(B$2:B$200,C2)

Ademisoye, Tracy Folake

can't match with

Ademisoye, Tracy Folake

even though they are on the same line