Team,
I need to subtotal the numeric at the same time it should also divide if the subtotal is more then 25 and pick the reference number from dataset and also do the subtotal till 25.
can anyone help me - please.
Thanks,
Data Set | Subtotals | Output |
24 | 24 | 24 |
1 | 25 | 25 |
19 | 44 | 19 |
1 | 45 | 20 |
5 | 50 | 25 |
5 | 55 | 5 |
9 | 64 | 14 |
6 | 70 | 20 |
1 | 71 | 21 |
5 | 76 | 5 |
18 | 94 | 23 |
1 | 95 | 24 |
7 | 102 | 7 |
1 | 103 | 8 |
1 | 104 | 9 |
24 | 128 | 24 |
9 | 137 | 9 |
1 | 138 | 10 |
16 | 154 | 16 |
12 | 166 | 12 |
Solved! Go to Solution.
Thanks so much !
Hi @Myusrename001! My pleasure! Could you mark my post as a solution :D?! 😅