How to remove unsubscribed emails from your large email list spreadsheet?

How to remove unsubscribed emails from your large email list? @Spreadsheet-Hacks

This solution is based on the Apache OpenOffice Calc spreadsheet application/software.

Let’s say you have a spreadsheet with 10000 emails listed on Column C and would like to remove the 400 unsubscribed emails listed on Column D while keeping the unique emails listed on Column C connected to the corresponding Columns A and B.

Column A has a record ID
Column B has a record Name
Column C has a record Email

————————————————

Column D has the unsubscribed emails

On Column E, paste the Formula below and adjust E$1:E$400 to match the range of your unsubscribed emails in Column D.

=IF(ISNA(VLOOKUP(C1; D$1:D$400; 1; 0)); C1; “”)

Then select and Fill Down on Cell E1 to the last Row of records on Column C.

If the email in Column D is not found on Column C, it is copied from Column C to Column E. If found, it outputs an empty string (“”).

————————————————

Now let’s clean up the list by copying all of Column E and then Paste Special, check Values only and do not check Formulas, and paste on Column C.

Delete Column D and E

Then Sort Ascending, Expand Selection to include Column A, B and C.

The result should have the unsubscribed emails at the bottom of the list and can then be deleted.

The resulting list should only have the emails that were not unsubscribed.

Done.

I hope this helps you!

AAPM1000
@Spreadsheet-Hacks