Attached is a spend sheet. Column C contains a list of product descriptions. A number of the product descriptions end in "DIRECT DELIVERY" (or some variation of at least). What seems to be consistent is that the letter's "DIR" will always feature in the different variations.
I want to be able to identify all of the cells that feature "DIR" in them and then add a number "1" in a column next to it so these rows can then be filtered separately from the rest of the data.
Is this at all possible?