de-duplicating customer list based on reference list

I have two customer lists, both from different systems. 1st list is a reference list of existing active accounts, while 2nd list is from an acquisition. I’ve been tasked with figuring out which of the accounts on the 2nd list are NOT already in the 1st list and then returning the 2nd list fully de-duplicated with all 20+ columns the way I received the file. 

I’ve tried learning Vlookup, and have made numerous attempts at remove-duplicates and didn’t understand well the VBA videos. I’m new and I don’t have any experience doing this. 

Help?

By: Anthony

Leave a Reply

Your email address will not be published. Required fields are marked *