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