PDA

View Full Version : EXCEL - How to remove duplicate emails from list 2 that are in list 1???




worm
Sep 12, 2008, 03:56 AM
Hi all, ok I'm a Graphic designer not a technical guy - I'm working on a :apple: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
Sep 12, 2008, 09:48 AM
Do you mean Entourage and not Excel? Excel is a spreadsheet app.

Corrado33
Sep 12, 2008, 11:37 AM
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
Sep 12, 2008, 11:54 AM
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