How to delete entire row of data, by type of text?

Not sure if I phrased the subject of this post right.

But, I have an excel spreadsheet and the last row of fields contains a list of email addresses in one of the columns.

There are some email addresses that are bad, an I need to find a way where I can delete an entire field of data. Right now, I have been manually deleting the entire row of data, if the email in the email field is no longer valid. But I have over 5000 columns of data, and it takes a long time.

Is there a way where I can just plugin a list of emails that are not valid, and have that entire row of data deleted, if that row has that email address?

I hope that makes sense

Many ways to resolve this.

Type in your list of invalid emails. Lets say it is in J1:J5.
Create a helper column that has this type of equation (I'll assume your list of emails is A1:A1000) in cell B1: =MATCH(A1,$J$1:$J$5,0)
Drag that equation down to B1000
Now sort that table using column B
Now, everything with an #N/A error is legit, so do a block delete on the rows that have a number in column B