Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
not entirely sure, but as far as I know the Solver add-in needs input as to
which cells can be changed in order to get an outcome. If you have multiple variables, changing another variable might give an alternative answer. Perhaps you are asking about the problem when changing one cell can also have alterantive answers, for example with a1^2 where both negative and positive can give correct solutions. Not sure what happens if you try different start values - as I don't know what algorithm is used by the Add-IN.... rdwj "Zarlot" wrote: Hello, I have used the Solver Add-In to come up with combinations before, but one drawback is that (or at least I'm not aware how to) one can only come up with one combination. There may, however, be several combinations that come up with a certain sum. Does anyone know of any Add-Ins or VBA macros that would accomplish this task? Thank you very much! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Getting Excel to Calculate All Combinations of a Set of Data? | Excel Worksheet Functions | |||
I have 5 columns of data and want to create combinations based on | Excel Discussion (Misc queries) | |||
When I add cells the sum is coming up $0.00 | Excel Discussion (Misc queries) | |||
I'm always coming up against this! | Excel Discussion (Misc queries) | |||
Coming up with #N/A | Excel Worksheet Functions |