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"...