Hello,
I.ve got a small problem, maybe someone can help.
In a column i've got the values shown beneath.
Col AM
ROW 1 xxxxxxxcxxcxccxcccxxxxxxx
ROW 2 xcccccxccccxccccxcxcccccx
ROW 3 xcxxxcxcxxccxcxxccxcxxxcx
I''m looking for a formula that counts the value "x"until the value "c".
So,
A1, counts the first set of "x" .
B1, counts the second set of "x"
C1, 3th set of "x"
this would be repeated with max 10 colums
The outcome will be something like this:
Column A B C D E F G H
ROW 1 ) 7 2 1 1 7
ROW 2 ) 1 1 1 1 1 1
ROW 3 ) 3 1 2 1 2 1 3 1
Anyone an idea?
Thanks in advance.
ABBOV
Bookmarks