Anita,

Lots of methods fo duplicates he-

http://www.cpearson.com/excel/Duplicates.aspx

Mike

"Anita" wrote:

Hi

I've got 2 columns of data and want to find out if a value in col A exists
anywhere in column B - I thought the match function might do this but I can't
work it out.

Thanks

Anita