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

5 thoughts on “de-duplicating customer list based on reference list

  1. ig

    You actually make it seem so easy with your presentation but I
    find this topic to be really something that I think I would never understand.
    It seems too complex and extremely broad for me. I’m looking forward for your
    next post, I’ll try to get the hang of it!

  2. Lillia Scampoli

    Awesome blog! Is your theme custom made or did you download it from somewhere? A theme like yours with a few simple tweeks would really make my blog stand out. Please let me know where you got your design. Bless you

Comments are closed.