Delete Multiple Rows based on Criteria

Hello,

Have an interesting question today:

I have a spreadsheet containing several thousand rows.

My column headers are: Group Number, Field Name, and Value.

I am looking to delete all rows if Value Column = 4 or 7.

So if Group 1 has a Value of 4 and/or 5, Then delete all Group 1.
Group 2 does not have a value of 1 or 2 so it is fine.
Group 3 has a value of 4 so delete all Group 3 rows.

Any thoughts?

Thanks