I'm struggling with an issue I have deleting cells with specific criteria. The criteria is "Payslips", "Salary", "No pay / reduced pay" which may or may not be listed in column "S". Column "S" contains unique values.
If a cell within column "S" contains one of the above criteria, I need it to then delete that cell and offset(0'1)
I've tried various options but majority of what's out there deletes the entire row.