EXCEL - How to remove duplicate emails from list 2 that are in list 1???

Do you mean Entourage and not Excel? Excel is a spreadsheet app.

 

So you want to remove the e-mails from list 2 that are in list 1. Meaning if somebody@somewhere.net is in list 1 you want it removed from list 2. Kind of like you have a list of people that are no longer part of the e-mail mailing list and you want to remove those e-mails from the mailing list.

 

This should do it:

• Combine list 1 and 2
• Select the entire column where list 1 and 2 combined
• Go to Data > Filter > Advanced Filter
• If a message comes up just click "OK"
• For Action select "Copy to another location"
• Where it says "Copy to" - enter in which column/rows you want to paste it to. Example $C$1
• Then check the box that says "unique records only"
• Select Ok

MC