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..
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 range
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 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks