Using Excel 2000
Hi,
I have got data in column B
1-I want sum max consecutives in between intersections of "X" and put sum in column C
2-I need count max consecutives in between intersections of "X" and put sum in column D
3-Highlight max consecutives in the column B
Example data...