Hello Tortus,

Row 26 goes and row 27 stays. So, delete duplicates if there is no OK in column "D". Do you want just the value in cell "B" deleted or other columns in that same row deleted as well?

Sincerely,
Leith Ross