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..
Thank you in advance
Regards,
Kishan
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..
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Data | Sum Max Consecutive | Count Max Consecutive | ||||
2 | 1,1,1,1,1,1,1,1,1,1,1,1,1,1 | 14 | 14 | ||||
3 | 1,1,1,1,1,1,1,1,1,1,1,2,1,1 | 15 | 14 | ||||
4 | 1,1,1,1,X,X,1,1,X,2,1,X,X,1 | 4 | 4 | ||||
5 | 1,1,1,1,2,1,2,1,2,X,1,2,2,2 | 12 | 9 | ||||
6 | 1,1,1,1,2,X,X,X,2,1,2,X,2,X | 6 | 5 | ||||
7 | 1,1,1,1,2,X,X,2,X,2,1,2,X,X | 6 | 5 | ||||
8 | 1,1,1,X,2,1,1,2,1,X,2,1,X,2 | 7 | 5 | ||||
9 | 1,1,1,2,1,1,2,1,X,2,1,2,X,1 | 10 | 8 | ||||
10 | 1,1,1,2,X,X,2,X,2,1,1,1,X,2 | 5 | 4 | ||||
11 | 1,1,1,2,X,X,2,X,2,1,X,1,1,X | 5 | 4 | ||||
12 | 1,1,X,1,X,1,X,X,X,1,1,2,2,X | 6 | 4 | ||||
13 | 1,1,X,1,X,1,X,X,X,1,X,2,1,2 | 5 | 3 | ||||
14 | 1,1,X,1,2,2,X,X,2,2,1,X,2,1 | 5 | 3 | ||||
15 | 1,1,2,1,X,1,1,X,2,X,1,X,X,X | 5 | 4 | ||||
16 | 1,1,2,1,X,X,X,1,X,2,X,2,1,1 | 5 | 4 | ||||
17 | 1,1,2,1,X,X,X,1,X,2,2,1,2,X | 7 | 4 | ||||
18 | 1,1,2,1,2,1,2,2,2,1,1,1,2,X | 19 | 13 | ||||
19 | 1,X,X,X,X,X,2,2,X,1,X,2,X,1 | 4 | 2 | ||||
20 | 1,X,X,2,X,1,X,X,2,2,1,X,2,1 | 5 | 3 | ||||
21 | 1,X,X,2,X,1,X,X,2,2,2,1,1,2 | 10 | 6 | ||||
22 | 1,2,2,X,X,1,X,2,X,2,X,X,2,1 | 5 | 3 | ||||
23 | 1,2,2,X,X,1,X,2,X,2,2,2,1,1 | 8 | 5 | ||||
24 | 1,2,2,2,1,1,2,1,1,1,2,1,1,X | 18 | 13 | ||||
25 | 1,2,2,2,1,2,1,2,1,X,2,1,2,X | 14 | 9 | ||||
26 | 2,X,X,1,1,1,X,1,2,2,X,X,1,2 | 5 | 3 | ||||
27 | 2,X,X,1,X,1,X,2,1,X,2,1,1,X | 4 | 3 | ||||
28 | 2,X,X,1,X,2,X,2,X,1,1,2,2,X | 6 | 4 | ||||
29 | X,1,1,1,1,X,1,1,2,2,2,X,2,2 | 8 | 5 | ||||
30 | X,1,1,1,X,1,2,1,2,X,1,2,1,2 | 6 | 4 | ||||
31 | X,X,2,X,2,X,2,1,2,2,1,2,X,1 | 10 | 6 | ||||
32 | X,X,2,X,2,2,X,2,1,2,2,1,X,X | 8 | 5 | ||||
33 | 2,X,X,X,2,2,X,2,1,1,X,X,1,2 | 4 | 3 | ||||
34 | 2,X,X,2,X,X,X,2,1,2,1,2,2,X | 10 | 6 | ||||
35 | 2,X,X,2,X,X,X,2,1,2,X,2,2,1 | 5 | 3 | ||||
36 | 2,X,X,2,X,2,1,X,1,2,2,2,1,X | 8 | 5 | ||||
37 | X,X,1,2,1,2,2,X,X,X,X,X,1,X | 8 | 5 | ||||
38 | X,X,1,2,2,1,2,1,2,1,2,2,X,2 | 16 | 10 | ||||
39 | X,X,X,X,1,1,1,1,2,X,1,2,2,1 | 6 | 5 | ||||
40 | X,X,X,X,X,1,2,2,2,2,1,1,2,1 | 14 | 9 | ||||
41 | X,X,X,X,X,1,2,2,2,2,X,2,2,X | 9 | 5 | ||||
42 | |||||||
43 | |||||||
44 | |||||||
Sheet1 |
Thank you in advance
Regards,
Kishan
Last edited: