Container A - F, as shown in the figure, A - G, people in order to hand the ball A - G, in turn, as far as possible in the container A - F, such as people put two goals in A container, A person must put three goals in A, B A into B, until the container to fill or everyone after the ball so far
The final statistics each person in each container with several balls
Probably is a problem, so now you can think of way of thinking is everyone update data after put a ball, can make a judgment to continue to put, not just on the next, or similar if the residual count & gt; Remaining quantity of the container is all in, or in the number remaining after judgment under such a calendar again
But because of the need to deal with the amount of data is large, and the boss can't understand VBA, so if we can try to use the formula to add auxiliary solution is the best, if not, VBA to deal with if there is a more convenient way?
Please feel free to comment