I'm not so good in excel but i "think" my problem can be solved using excel.. I've got a column with numbers and i'd like to find the best combination of using these numbers. In our case the best combination is a sum of three of those numbers that is as close as it can get in our goal number.
For example, we have a goal of 100 and a column filled with numbers these 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 3numbers combination (something like recursive sum distribution)?