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

Discussion in 'Mac Basics and Help' started by worm, Sep 12, 2008.

  1. worm macrumors newbie

    Sep 12, 2008
    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 :)
  2. NAG macrumors 68030


    Aug 6, 2003
    Do you mean Entourage and not Excel? Excel is a spreadsheet app.
  3. Corrado33 macrumors member

    Sep 2, 2008
    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.
  4. MCRunning macrumors 6502

    Sep 8, 2008
    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


Share This Page