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

[worm]

Hi all, ok I'm a Graphic designer not a technical guy - I'm working on a iMac G5 in EXCEL - and need help on How to remove duplicate emails from list 2 that are in list 1???

Does anyone have a link or could be so kind as to post me the several steps necessary to accomplish this feat!

Thanks in advance

Worm

 

[NAG]

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

 

[Corrado33]

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.

 

[MCRunning]

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