Comparing and Deleting Some values

[Yohasakoura]

Hello everyone can you please help me in my problem, how can i Compare two lists Containing each email addresses and Delete the matched Emails addresses from the first list, the main list is L1 and the second list in L2 which contains the emails that should be taked off from the Main list. in other words my list contains email addresses which doesn't exist anymore ( Hard bounce ) i managed to collect those emails that doesn't exists deleting them one by one from the main list isn't something easy to repeat 500 Times .

<tbody>
</tbody>

 

[FDibbins]

Cant do the deleting with formulas, you would need VBA for that.

However, you coul use he MATCH function to ID those entries to delete, filter based on those, then mass-delete them that way?

 

[Yohasakoura]

Yeah for sure that would be great th emost important thing is those emails must be delete from the main list and if you can help me with VBA that would be great cuz im not a proffesional