Thread: comparing data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anthony Anthony is offline
external usenet poster
 
Posts: 275
Default 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