| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What combination of numbers in a series sums to a specific value?
How do I find what combination of numbers in a series sums to a specific
value? I have the end sums and a list of values, some of which may be used and some of which may not, and I need a way to add the values in whatever combinations to equal all the sums. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What combination of numbers in a series sums to a specific value?
Check out this Tom Ogilvy classic for a way using Solver:
http://tinyurl.com/5kx9bw -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Ashley" wrote: How do I find what combination of numbers in a series sums to a specific value? I have the end sums and a list of values, some of which may be used and some of which may not, and I need a way to add the values in whatever combinations to equal all the sums. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What combination of numbers in a series sums to a specific val
Extraordinary! Thanks so much, Max. It worked like a charm for all three of
my sums. Ashley "Max" wrote: Check out this Tom Ogilvy classic for a way using Solver: http://tinyurl.com/5kx9bw -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Ashley" wrote: How do I find what combination of numbers in a series sums to a specific value? I have the end sums and a list of values, some of which may be used and some of which may not, and I need a way to add the values in whatever combinations to equal all the sums. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combination charts: two variables in one series? | Charts and Charting in Excel | |||
| How do I add the sums of a group of columns to a series in chart? | Charts and Charting in Excel | |||
| Combination chart - want only ONE series showing as a line, not 2. | Charts and Charting in Excel | |||
| How do I alter the number of bar series in a combination chart? | Charts and Charting in Excel | |||
| What function will check a row for a series of specific numbers? | Excel Discussion (Misc queries) | |||
Linear Mode
