How to cross-ref two lists in Excel and remove duplicates?
November 14, 2008 8:10 AM Subscribe
Excel-filter: I've got two sheets of data (Firstname, e-mail, lastname, customer #). I'd like to look for and remove any duplicate entries. More inside.
posted by GilloD to Technology (13 answers total) 2 users marked this as a favorite
I'm updating our customer e-mail newsletter mailing list. No one has done this in about a year. In that year our list of 20,000 names has dwindled to about 15,000. I have that list of 15,000 with bounces and unsubscribes removed. There are a few operations I want to perform to bring the list up to speed:
-People can opt-in to our newsletter when they buy something. This flags their customer entry in the shipping/inventory software but does NOT add them to the mailing list. I pulled a list of everyone who wants to get the e-mail from the last 6 months. I just want to cross-ref this list with the existing list AND with unsubscribes to make sure they didn't get in another way or have opted out since.
There are a couple of operations that happen in there. All of them come back to the same basic principal- To look at a sheet, or two sheets, and cross ref them looking for duplicates. If there's a duplicate, delete one of them.
This seems like it should be easy but I'm having a hell of a time. A Google search brings up lots of expensive add-ons but no real advice. Excel-ers of the world: HALP!