Delete these records

[ryrocks]

Hi,

I have a list of email addresses in excel.

I have another list of email addesses that what to be unsubscribed (deleted) from the first list.

How would I go about this?

Thanks,

Ryan

[Domski]

Say you have your original list in A1:A50 and the ones to delete in D1:D20 then in B1 copied down you could use =ISNUMBER(MATCH(A1,$D$1:$D$20,0)) which will return true for a match. You can then sort by column B and delete the ones you don't want to keep.

Dom