LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 95
Default Coming up with all possible combinations that add to a certain sum

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting Excel to Calculate All Combinations of a Set of Data? marello Excel Worksheet Functions 11 May 1st 23 03:42 AM
I have 5 columns of data and want to create combinations based on Carbob Excel Discussion (Misc queries) 0 June 2nd 06 04:58 PM
When I add cells the sum is coming up $0.00 Mike O Excel Discussion (Misc queries) 0 March 24th 06 07:45 PM
I'm always coming up against this! Michelle Tucker Excel Discussion (Misc queries) 6 May 21st 05 09:31 AM
Coming up with #N/A Rj Excel Worksheet Functions 4 December 28th 04 07:03 PM


All times are GMT +1. The time now is 02:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"