If I understood well your question, this formula in C1 (and dragged down as
necessary) returns TRUE if value in column A is found in column B, FALSE
otherwise.

Regards,
Stefi


€žChris Hankin€� ezt Ã*rta:

Hello,

Could some please help me with the following?

I wish to compare the text in column A of my workbook with the text in
column B to determine all the data in column A which is not contained in
column B.

I have no idea on how to accomplish this task, so any help would be
greatly appreciated.

Thanks,

Chris.



*** Sent via Developersdex http://www.developersdex.com ***