how to filter data and delete double records

Hi,
I have two worksheets. Worksheet1 has two columns: column A with names and column B with email addresses.
(approx. 4500 addresses) Worksheet 2 has one column with approx 4900 email addresses. I now would like to delete all email adresses + corresponding names in Worksheet1 that are the same as the email addresses in Worksheet2.
What is the easiest way to do that?

Originally Posted by **dan**

Hi,
I have two worksheets. Worksheet1 has two columns: column A with names and column B with email addresses.
(approx. 4500 addresses) Worksheet 2 has one column with approx 4900 email addresses. I now would like to delete all email adresses + corresponding names in Worksheet1 that are the same as the email addresses in Worksheet2.
What is the easiest way to do that?

following post might help you (its for data within a single workbook but you need to manipulate it according to two workbooks)

http://www.excelforum.com/showthread.php?t=577619

Originally Posted by starguy

following post might help you (its for data within a single workbook but you need to manipulate it according to two workbooks)

http://www.excelforum.com/showthread.php?t=577619

Hi,

Suppose there are mail ids in col 1 and col 2, put a formula in col 3
=if(coutif($A$1:$A$10,B1)>0,B1,"")

then u will c number 1 in front of the duplicate and there is nothing in front of the unique ids.


Regards,
Supriya