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.

Bob Weber

My name is Bob Weber and I live in Greeley Colorado. This blog is my personal views, ideas, comments, etc.. You will probably learn more about me by reading the entries here than you will in this bio.