Removing duplications across two spreadsheets

[DoubleJ87]

Hi I need some help working on my spreadsheets.

For example, say I have a spreadsheet containing a list of all the email addresses of customers for a business with over 10,000 email address and I also have a second spreadsheet containing 1000 email address who have recently opened a marketing email sent out to them. The 1000 in the second spreadsheet are also in the original 10,000 in spreadsheet 1. How would I go about removing the email addresses in spreadsheet 2 from spreadsheet 1 so that I would then be left with the 9,000 email addresses who have not recently opened marketing emails?

Thanks

[BB1972]

Hi DoubleJ87,

You can make use of the INDEX / MATCH function to identify the data you're looking for. Have a look at my example workbook - you'll see that I've introduced a column to indicate if the email address in your MASTER list (10,000 addresses) matches an email address in your OPENED/READ EMAIL list. So, in Cell C2, the code is:

Please Login or Register  to view this content.

This looks at the email address in B2, then looks at all the email addresses on the OPENED LIST, and if there is a match (for B2), it returns that email address in C2. Copy this formula to the end of your range in Column C, use the Data filter to filter out actual email address - in other words, for your filter choose only "#N/A", and you will identify the email addresses who did not open a marketing email.