Forumula to Find a Sum

[ketihd203]

Is there a formula that will analyze a string of numbers and determine which numbers will add to a particular sum?

For example, I have the following numbers:

10.00
25.00
36.05
29.00
4.30
3.98
256.00
20.00

I want to enter a formula to find out which of these numbers will add up to 75.96, and have the formula return:

36.98
10.00
25.00
3.98

Hope that makes since.

 

[Armando Montes]

See this:
http://www.tushar-mehta.com/excel/templates/match_values/index.html#VBA_multiple_combinations

 

[ketihd203]

thank you, that's exactly what I needed.