check range for certain value
I want to check a range (P:T) in every row. These cells will contain 2
letter codes, if the code 'MS' is found ON ITS OWN then I want to delete
that row. The number of rows on the sheet will vary.
Examples:
MS TG do not delete
MS delete
no codes at all do not delete
BB DD FG TR do not delete
Thanks in advance.
Gareth
|