Good Afternoon all,
I have an index /match formula that produces text results in a single column.
e.g.
string 1
string 2
string 1
Now I am trying to count up the diferrent results using a countif formula and it doesn't seem to be working (Coutif returns 0 if looking for "string 1" and not the expected / hoped for "2"). Is there any way to force the countif formula to read only the formula results and not the index / match formula?
Hope you can help?
I have an index /match formula that produces text results in a single column.
e.g.
string 1
string 2
string 1
Now I am trying to count up the diferrent results using a countif formula and it doesn't seem to be working (Coutif returns 0 if looking for "string 1" and not the expected / hoped for "2"). Is there any way to force the countif formula to read only the formula results and not the index / match formula?
Hope you can help?