I have for values in Col D and Branch + "PL" or Branch + "statement" in Col B eg BR1 PL or BR1 Statement
I need to set up a formula so that where the value is the same and the branch in Col B contains "PL" and "Statement" for the same value then display "Delete" , otherwise blank
I have shown what the result should look like in Col F by manually inserting Delete
your assistance in this regard is most appreciated
Bookmarks