I need an excel formula or VBA to solve below problem. So I need you guys to help me please:)
My problem is :
I have a table as blow with given total request and values. What I need is generate new value and the total of those values should give me closest total to "Total Request"
So the generation of new values should stop when it reach >= Total request.
Given Table :
Total Request 35 Value New Value 1 2 3 14 21 12
Total Request 35 Value New Value 1 1 2 2 3 3 14 14 21 12
Thanks in advance :)