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 range

[Blah]

MDubbelboer wrote:
> 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
>
>
> --
> MDubbelboer
> ------------------------------------------------------------------------
> MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330
> View this thread: http://www.excelforum.com/showthread...hreadid=562226

Only works with numbers not text....

[MDubbelboer]

works fine with text in excel 2003

[Blah]

MDubbelboer wrote:
> works fine with text in excel 2003
>
>
> --
> MDubbelboer
> ------------------------------------------------------------------------
> MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330
> View this thread: http://www.excelforum.com/showthread...hreadid=562226


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