View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JP[_8_] JP[_8_] is offline
external usenet poster
 
Posts: 4
Default Count each group of values

I need a formula or vba code to count how many groups of "X" values and how
many "X" in each group.
Sample:

a1
ah1
X X X X X X X A A A A X X X X X X B B B B B B X X X X X X X X X X X X

Result i need with the code or formula
1 group 7 "x"
2 group 6 "x"
3 group 12"x"

Thanks for help
Paulo