Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Finding possible sums to match a figure
I have a list of numbers, some of which total a value. I would like to find
a formula or function which will search through the possible numbers and tell me the suggested combinations which equal this number. Thanks for any advice you can give on this. |
#2
|
|||
|
|||
Jodi,
You can do that for up to about 30 values - beyond that it becomes too big of a problem for a PC. I have an example workbook that I can email to you if you contact me privately. Reply to me, but take out the spaces and change dot to . in my address. HTH, Bernie MS Excel MVP "Jodi" wrote in message ... I have a list of numbers, some of which total a value. I would like to find a formula or function which will search through the possible numbers and tell me the suggested combinations which equal this number. Thanks for any advice you can give on this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding a match in several columns | Excel Worksheet Functions | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Finding a match | Excel Discussion (Misc queries) | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |