comparing data
 

I have data in column A, 14 digit number; by cutting and pasting from another
data collection file place a smaller amount of data in column B also 14 digit
numbers; have to find those numbers in A that are also on B column and delete
the record.

Is there a way of doing bulk find and delete

cheers

comparing data
 

Hi Anthony,

try this way

http://www.j-walk.com/ss/excel/usertips/tip073.htm

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Anthony" escreveu:

I have data in column A, 14 digit number; by cutting and pasting from another
data collection file place a smaller amount of data in column B also 14 digit
numbers; have to find those numbers in A that are also on B column and delete
the record.

Is there a way of doing bulk find and delete

cheers