Code to delete entire row if multiple criteria is met

[lucasc10]

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!