Hello,
I'm facing a problem and have no idea how to solve this.
Here is my problem:
I have 2 excel files. 1 has 10 columns and about 20.000 rows. Each row is a customer entry and each column specifies data about the customer (column 1 first name, column 2 last name, column 3 email, column 4 city and so on). The 2nd excel file only contains 1 column with 4000 email addresses in it. These are email addresses of people who opted out of our newsletter and other marketing channels.
Now I want to have excel delete all the rows of the first file that correspond to the email addresses of the 2nd file. Obviously the email addresses in both files are identical, though the 2nd one contains fewer entries and only those people we don't want to continue sending emails to.
Could some excel master step out and show me the light? I would truly appreciate this as I've spent a bunch of time and nerves already googling around but the advice given usually only applies if the data of both excel files is the same.
Thank you very much,
John M.
Bookmarks