Hi guys,
Need your help!
My problem is how am I gonna distribute my remaining values based on my total output. then if the remaining value is 0 and my total output does not meet it yet, it will continue on its next cell.
B1:F1 is my remaining Values
G3:G11 is my Total output
B3:F11 is where I need to put your formula.
A | B | C | D | E | F | G | |
1 | 41.5 | 38.5 | 96.5 | 42.5 | 125.5 | ||
2 | G056 | I076 | K090 | H060 | M113 | OUTPUT | |
3 | 1-DEC | 43 | |||||
4 | 2-DEC | 42 | |||||
5 | 3-DEC | 44 | |||||
6 | 4-DEC | 49 | |||||
7 | 5-DEC | 46 | |||||
8 | 6-DEC | 40 | |||||
9 | 7-DEC | 0 | |||||
10 | 8-DEC | 0 | |||||
11 | 9-DEC | 0 | |||||
12 | TOTAL: | 0 | 0 | 0 | 0 | 0 | 264 |
This is my goal for my table:
A | B | C | D | E | F | G | |
1 | 0 | 0 | 0 | 0 | 80.5 | ||
2 | G056 | I076 | K090 | H060 | M113 | OUTPUT | |
3 | 1-DEC | 41.5 | 1.5 | 43 | |||
4 | 2-DEC | 37 | 5 | 42 | |||
5 | 3-DEC | 44 | 44 | ||||
6 | 4-DEC | 47.5 | 1.5 | 49 | |||
7 | 5-DEC | 41 | 5 | 46 | |||
8 | 6-DEC | 40 | 40 | ||||
9 | 7-DEC | 0 | |||||
10 | 8-DEC | 0 | |||||
11 | 9-DEC | 0 | |||||
12 | TOTAL: | 41.5 | 38.5 | 96.5 | 42.5 | 45 | 264 |