Formula to delete entire row if multiple criteria is met

I am generally good at Excel, but can't figure this out... I am trying to figure out a way to have my Excel delete everything with an "N" in the second column, but ALSO delete all of the instances in column one where there is a duplicate number that contains an "N" at some point. This is hard to describe, but I'll give an example in the workbook attached. I would want everything highlighted to be deleted. They all contain an "N" in the row that should be deleted or have the same column A number as the one above it that contains an "N". Please let me know if you have any questions... Thank you!

This is a duplicate thread, which is not allowed on this forum. You should continue in your other thread, and attach the file to that one.

A formula cannot directly delete a row in Excel - you can use a formula to identify records which need deleting (e.g. with a Yes or No), and then manually delete those records in one go (e.g. using autofilter).

Hope this helps.

Pete