So you need to find all cells with the word "ABC" in column "B" and if its found then delete the whole row. Correct?

Thanks