Hi
a number in column A and either zeros or 1's in column B. the data is like this
23 1
12 0
21 0
32 0
23 1
43 0
23 0
21 1
43 0
45 1
11 1
What i need in Column C is the MAX number in Column A for each consecutive 1 in B. so the result should be like this.
23 0
12 0
21 0
32 0
24 1 32
43 0
23 0
21 1 43
44 0
45 1 45
11 1 11
I hope its understandable
Peace.
a number in column A and either zeros or 1's in column B. the data is like this
23 1
12 0
21 0
32 0
23 1
43 0
23 0
21 1
43 0
45 1
11 1
What i need in Column C is the MAX number in Column A for each consecutive 1 in B. so the result should be like this.
23 0
12 0
21 0
32 0
24 1 32
43 0
23 0
21 1 43
44 0
45 1 45
11 1 11
I hope its understandable
Peace.