Count each group of values

[JP]

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

 

[Kieran]

JP,

Bob Umlas has all the answers at
http://www.emailoffice.com/excel/arrays-bobumlas.html

 

[JP]

Thanks