Find Combinations that Sum to "X"

[JonesyUK]

Dear Experts,

I have the following list of numbers in cells A1 to A21 of sheet1:

60,839.64
64,340.83
66,785.86
69,943.82
73,861.63
76,001.87
78,284.47
80,012.83
87,498.18
88,548.04
89,484.91
97,662.06
97,666.53
105,572.28
105,600.35
107,288.25
108,846.57
110,407.36
125,648.42
131,501.42
146,520.93

I need to find a combination of the above numbers that totals 333,173.77 (if any)....

Can you please help me with some kind of solution to be able to do this....

Many thanks!

JonesUK

 

[VoG]

This should help you http://www.tushar-mehta.com/excel/templates/match_values/index.html

 

[hiker95]

drclintjones,

See:

Which numbers add up to a specific total
http://www.tech-archive.net/Archive...cel.worksheet.functions/2009-01/msg04130.html
VBA Sub by Harlan Grove.
There seems to be one flaw: if the table is sorted ascending and the first n numbers sum up to the required value exactly,
it will miss that combination. I don’t know if this has been corrected later.
Note the requirements for your settings documented in the code itself