Hi Gurus,
I have below data sample, I want to update 1 on every record in B1 till i get 15 , once i get 15 i will have to update 15 to all 0 till 33 and goes on... please check my data sample so my question would be very clear. Also for convenience we have A1 column which corresponds to B1 values in a sequence way.
I tried in many ways but unable to get the right result, Please suggest me the way. Thank you.
A1 B1
| 1 | 1 |
| 2 | 0 |
| 3 | 0 |
| 4 | 0 |
| 5 | 0 |
| 6 | 0 |
| 7 | 0 |
| 8 | 0 |
| 9 | 0 |
| 10 | 0 |
| 11 | 0 |
| 12 | 0 |
| 13 | 0 |
| 14 | 0 |
| 15 | 15 |
| 16 | 0 |
| 17 | 0 |
| 18 | 0 |
| 19 | 0 |
| 20 | 0 |
| 21 | 0 |
| 22 | 0 |
| 23 | 0 |
| 24 | 0 |
| 25 | 0 |
| 26 | 0 |
| 27 | 0 |
| 28 | 0 |
| 29 | 0 |
| 30 | 0 |
| 31 | 0 |
| 32 | 0 |
| 33 | 33 |
| 34 | 0 |
| 35 | 0 |
| 36 | 0 |
| 37 | 37 |
| 38 | 0 |
| 39 | 0 |
| 40 | 0 |
| 41 | 0 |
| 42 | 0 |
| 43 | 0 |
| 44 | 0 |
| 45 | 0 |
| 46 | 0 |
| 47 | 0 |
| 93 | 0 |
| 94 | 0 |
| 95 | 0 |
| 96 | 0 |
| 97 | 0 |
| 98 | 0 |
| 99 | 0 |
| 100 | 0 |
| 101 | 101 |
EXPECTED OUTPUT :
A1 B1
1 1
2 1
3 1
4 1
5 1
6 1
7 1
8 1
9 1
10 1
11 1
12 1
13 1
14 1
15 15
16 15
17 15
18 15
19 15
20 15
21 15
22 15
23 15
24 15
25 15
26 15
27 15
28 15
29 15
30 15
31 15
32 15
33 33
34 33
35 33
36 33
37 37
38 37
39 37
40 37
41 37
42 37
43 37
44 37
45 37
46 37
47 37
93 37
94 37
95 37
96 37
97 37
98 37
99 37
100 37
101 101