Are you an excel wizard??? I need your magic! I am by no means anything CLOSE to an excel wizard. I don't know how to do formulas, etc, and am mainly looking to see if there is some form of Macro / automated process in doing this. I work for a small start-up company where we all wear a dozen hats and it has been delegated to me to figure this out, and my internet searching lead me to this forum!
I have two huge email lists. We're talking just over 300k
1 email address list is a list of people who have unsubscribed from a mailing list. Let's call this list A which has about 100k folks.
The second list is a big list (300k) that I need to make sure that if an address exists in list A, it needs to be removed. Let's call this list B.
I need to make a NEW list, which we'll call list C. List "C" will be a safe list if you will, meaning we took list "A" and cross-referenced it against list "B", and as long as list "A" didn't unsubscribe from list "B", we can stick them in the safe list "C".
Make sense? I know that there are excel wizards who will see this and say "no problem", put in a simple formula and render this out in a few minutes.
Let me know if you have any further questions! Thank you. Need this done sooner than later =)
PS- It really surprises me that there isn't a simple place to go online to upload two .csv's / excel workbooks and have it spit out a rendered sheet at the click of a few buttons.
Thank you!
~Nick
Bookmarks