how to get excel to combine numbers to a given total

[karlo]

I receive a list of numbers. I need to find
out which amounts will add up to a given total. How would I create a macro
to do this? Is there already an Excel function to do this that I have not
found? It would need to work with currency.

Ex: 9, 12, 7, 4, 15, 8, 10, 3 total needed 18
Solution 8+10; 3+15

 

[Jacob Skaria]

Hi Karlo

You can have a macro to do this to list all the possible combinations.

Do you have format in which the data is currently in.

If this post helps click Yes

 

[macropod]

Hi karlo,

See: http://www.tek-tips.com/viewthread.cfm?qid=1485698

 

[Dana DeLouis]

Ex: 9, 12, 7, 4, 15, 8, 10, 3 total needed 18

Solution 8+10; 3+15

Is 3+7+8 a solution also?

= = =
Dana DeLouis

 

[amontes]

 > Ex: 9, 12, 7, 4, 15, 8, 10, 3   total needed 18
 > Solution 8+10; 3+15

Is 3+7+8 a solution also?

= = =
Dana DeLouis





- Show quoted text -

Hi Karlo, check this out:
http://www.geocities.com/excelmx/SumTarget.xls