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

Countif doesn't seem to work