Removing duplicates from two columns in Excel

I work with a lot of email lists, and constantly have a difficult time filtering out duplicates from two lists. The system we use will remove duplicates on an import, but has no method of removing addresses in an existing list from a new list. (does that make sense?)

Often what we end up doing is pulling them into Excel (or your favorite spreadsheet program) and trying to sort out the dupes there, but it’s a little tricky.

Recently, found this great tutorial, from Microsoft no less, that explains exactly how to do it.

Share and Enjoy:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay

Related posts:

  1. Removing smartquotes from text in Linux When converting documents from customer word format to html it...
  2. Stack Overflow and Joel Spolsky’s Fog Creek Software Management Training Program Reading List I’m a big podcast fan. Originally, I was mostly into...
  3. Dell charges for ‘Downgrade’ Dell Inc. will charge customers up to $50 for factory-installed...
  4. The worst foods Forbes has a great list of the worst foods you...
  5. Handy Zombie Guide Came across this handy Zombie Guide recently. Thought I would...