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..

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

--
MDubbelboe
-----------------------------------------------------------------------
MDubbelboer's Profile: http://www.excelforum.com/member.php...fo&userid=3633
View this thread: http://www.excelforum.com/showthread.php?threadid=56222

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....

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

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