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

 

[Simon Lloyd]

Do the figures appear in seperate cells?, do you want the the results i
seperate cells

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

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

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

[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