redneckopen
Board Regular
- Joined
- Nov 2, 2004
- Messages
- 224
Lets say in A2 thru A5 I have 4 different codes for one product all with different amounts represented in B2 thru B5. I then have 7 different people I need to allocate those amounts to in columns C1 thru I1 evenly against their order in C2 thru I2. What would be the algorithm that could be used?
eg.
GROUP 1 GROUP 2 GROUP 3 GROUP 4 GROUP 5 GROUP 6 GROUP 7
7,500 18,122 3,545 21,776 12,124 5,488 7,210
SCB 26,542
SCW 15,885
SCA 7,122
SCV 65,124
eg.
GROUP 1 GROUP 2 GROUP 3 GROUP 4 GROUP 5 GROUP 6 GROUP 7
7,500 18,122 3,545 21,776 12,124 5,488 7,210
SCB 26,542
SCW 15,885
SCA 7,122
SCV 65,124
Last edited: