Hi,
I have following data and how to write VBA to get 39 and 22 and so on:
Once we see 1 in Column A. Strats adding next number in column B until next 1 in column 1.
Exanple: 39 = 5+5+6+7+3+8+3+2
22 = 9+6+3+4
Col-A Col-B
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
I have following data and how to write VBA to get 39 and 22 and so on:
Once we see 1 in Column A. Strats adding next number in column B until next 1 in column 1.
Exanple: 39 = 5+5+6+7+3+8+3+2
22 = 9+6+3+4
Col-A Col-B
1 | 39 |
2 | 5 |
3 | 5 |
4 | 6 |
5 | 7 |
6 | 3 |
7 | 8 |
8 | 3 |
9 | 2 |
1 | 22 |
2 | 9 |
3 | 6 |
4 | 3 |
5 | 4 |
1 |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>