| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find numbers that total o a specific sum
XP pro; Office 2003 Pro
I have a list of 285 numbers in column A, and I know some subset of these numbers totals to 406,666.45. I have no idea how many numbers make up this subset. I have tried a series of nested loops to sequentially combine the list in combinations of 2 to 5 numbers but I'm not getting anywhere. Can anyone here point me in the right direction? The only answer i've found searching the web leads me to an Experts something or other site, but they want $$ up fron for the answer. thanx |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to find numbers that total o a specific sum
see:
http://groups.google.com/group/micro...n&rnum=1&hl=en -- Gary's Student gsnu200704 "BAC" wrote: XP pro; Office 2003 Pro I have a list of 285 numbers in column A, and I know some subset of these numbers totals to 406,666.45. I have no idea how many numbers make up this subset. I have tried a series of nested loops to sequentially combine the list in combinations of 2 to 5 numbers but I'm not getting anywhere. Can anyone here point me in the right direction? The only answer i've found searching the web leads me to an Experts something or other site, but they want $$ up fron for the answer. thanx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum up combinations of numbers from list to get specific total | Excel Discussion (Misc queries) | |||
| EXCEL FIND A SPECIFIC TOTAL | Excel Worksheet Functions | |||
| which numbers add up to a specific total | Excel Worksheet Functions | |||
| Can I total only numbers with a specific font color? | Excel Discussion (Misc queries) | |||
| How do I add a range of numbers to sum a specific total? | Excel Worksheet Functions | |||
Linear Mode
