Zend certified PHP/Magento developer

Remove all duplicates BELOW based on “if” condition in another column

can someone help me figure out how to get Excel to do the following:

IF (B2 = “YES”) remove all duplicates of B2 below it

Column A has (non-unique) phone numbers and Column B has “outcomes” (YES, MAYBE, and a handful of others) and I want Excel to remove all rows with a certain phone number after it first “got” the value “YES” in B, but keep all of the duplicates above it.

I’ve tried to make a few helper columns with IF statements to no success.

Thanks!