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!