B
Bill
I need to count the occurrence of a string that would be contained in text in a column.
For example, in column J, starting at cell 1,
J
1 x1 x4
2 x1 x2 x3
3 x2 x5
4 x3 x4 x6
(For example, cell J1 equals the text string "x1 x4".)
So, the answer to the number of times the string ''x4' occurs in J1:J4 is 2.
Is it even possible for this type of counting to be performed with an Excel formula?
How???
Thanks,
-Bill.
For example, in column J, starting at cell 1,
J
1 x1 x4
2 x1 x2 x3
3 x2 x5
4 x3 x4 x6
(For example, cell J1 equals the text string "x1 x4".)
So, the answer to the number of times the string ''x4' occurs in J1:J4 is 2.
Is it even possible for this type of counting to be performed with an Excel formula?
How???
Thanks,
-Bill.