I have cells that have data like
Cell 1 Con Con Con Con Con
Cell 2 Oft Con Som Con Som
They are codes for consistently, sometimes and often
I need a formula that will count the number of "Con"s in both cells,then the number of "Oft"'s etc. but they are separated by a space in cell 1 and cell 2.
Cell 1 Con Con Con Con Con
Cell 2 Oft Con Som Con Som
They are codes for consistently, sometimes and often
I need a formula that will count the number of "Con"s in both cells,then the number of "Oft"'s etc. but they are separated by a space in cell 1 and cell 2.