Finding a combination of values

[mtravis38]

Good afternoon,

I have a column filled with numerical values. I know that some combination of those numbers equals X. Is there a mechanism in Excel to find that combination? There are no limits on how many numbers could make up the combination.

 

[shg]

How many numbers in the list?

 

[Armando Montes]

Here is one solution:
http://www.tushar-mehta.com/excel/templates/match_values/index.html#VBA_multiple_combinations