I've got a column of numbers, and I'd like to find the best combination of three of these numbers. In our case, the best combination is a sum that is as close as possible to our goal number.
For example, we have a goal of 100 and this column of numbers:
15 70 36 60 30 53 37 17 0 75 100 9
If I sum
30+70+0=100 this group of 3 numbers (30,70,0) is the best combination since it reaches our goal number, 100. We can also get other combinations like,
60+30+9=99 and so on with the remaining numbers.
Is there a way through Excel (or anything else if you have in mind) that can list me the best three-number combination (something like recursive sum distribution)?