View Single Post
 
Old 10-14-2018, 02:52 PM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

You would need to use some VBA for this. Something like this where email addresses are in column D

Code:
Sub FilterDelete()
    With Range("D1", Range("D" & Rows.Count).End(xlUp))
        .AutoFilter Field:=1, Criteria1:="*@maildrop.com"
        .Offset(1).EntireRow.Delete
        .AutoFilter
    End With
End Sub
Note: Please first test on a copy of your data
Reply With Quote