Hi Franklin52,
Thanks for the quick respond..
Ok, I try to explain more details....
If every X followed by 0 is count as occurrence 1
e.g: X0 , XX0, XXX0, XXXX0, so on... count as occurrence 1
For example, if there is a range of data like this:
000X0X0000X0XX0XXX0XX00000X000
then, we can distinguishes like this:
000
X0X0 000
X0XX0XXX0XX0 0000
XXXXX0 00
X0X0 = count as occurrence 2 (there are two X0s)
X0XX0XXX0XX0 = count as occurrence 4
There are X0, XX0, XXX0, XX0
XXXXX0 = count as occurrence 1
So, the desired output of example above is:
2
4
1
(Remember, The range of data is displayed in row by row)
I hope you can understand my explanation
Thanks