Delete Rows Based On Cell Contents Matching Cell Contents in Other Worksheet

Hello All, This is my first visit and my first post in this group. I haven't been able to find the answer to an issue I have so here I am. I have worked with Excel and formulas for many years but ...

Formulas and Functions

Celia_Alves
May 08, 2019
TPCTech
you can do the following:
- make sure your main list is an Excel Table
- add one column to your contact list
- in the columns added, write a formula like this:
= IF(OR(ISNA(MATCH(email cell, email column in the Spam sheet, 0),
ISNA(MATCH(email cell, email column in the Unsubscribed sheet, 0),
ISNA(MATCH(email cell, email column in the Undeliverablesheet, 0)
),"delete", "")
- you should get the word "delete" in all the rows that have an email that is included in at least one of the other 3 sheets.
- filter the table in the column by "delete" and deleted the rows filtered

Let me know if this works. Good luck!