I have a column that displays individuals grades; I'm specifically looking for cells that match the grade O1,O2,O3,O4,O5,O6, and if the cell containing the data matches any of the substring above, I want it to reflect as a yes or no in a different cell column. Any assistance is greatly appreciated and the faster; the better!
Solved by T. J. in 14 mins