Can solver do this?

  • Thread starter Thread starter chrisrowe_cr
  • Start date Start date
C

chrisrowe_cr

Hi everyone, im new here. I have a reasonable knowlege of Excel, but my
question emphasises a gap in my knowledge!

ok, wondering if and how the solver function could achieve this:

list of numbers...

23
43
51
27
19
28

etc....

I want to find say for example the numbers that add upto 79 in that
list, can solver find which of the numbers ie 43+17+19 do so?
 
Hi,

Yes it can. Put the numbers you have in a column and add a column of zeros
next to them, and calculate =SUMPRODUCT () between the two. This becomes the
target cell for solver.

The cells to change are the columns of zeros and then you "just" have to add
the constraint that each of these is binary.

Finally, set solver to do Equal to Value of 79 in your example.

In this case I get the solution 51 + 28 btw!

HTH,

David
 
David's method works just fine for finding any solution. As David
hinted, you may need to add other constraints or definition to the
problem is you want to find a specific solution or find all possible
solutions.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Solver Problem ( related to earlier post of using if an Vlookup) 1
Please help.... 12
how do i Count with in the cell range value is >5 and <=15 1
Solving a puzzle using "Solver"? Can already do by Iteration & functions. 2
How to get the array like this? 6
Can solver do this? 2
Problem--- 3
sending an email i always get this error message 1

Back
Top