I have an issue.
Lets say I have 4 numbers (10, 50, 100, 250) and I want excel to give me the best combination of those numbers that will get me as close as possible to a target value of 999.
I can use the each number more than once (obviously).
And I want to duplicate the calculation for a lot of cells (each time the target value is different)
How can I do that?
Thanks in advance for the answers,