Closest Sum to a Given Number

[Onslaught17]

Hello,

I am trying to create some type of formula or VBA script that will look at a series of given numbers and identify which numbers if summed together are closest to another given number. For example if I am given the series of numbers shown below, which numbers if summed together are closest to 10 (10 is also a given number). The answer would somehow identify both fives in the series of numbers below.

1
1
1
5
5

Any help on this is greatly appreciated. Let me know if I need to go into further detail.

 

[arthurbr]

One of the many solutions/links https://www.tek-tips.com/faqs.cfm?fid=4742

 

[Onslaught17]

Thanks for providing this solution. I have been using this extensively lately but I am having two issues. The solver tool in excel is extremely slow and it only has the capability of identifying one set of numbers at a time.

You said you knew of many solutions. Would you mind pointing me in the right direction again?