| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using Excel Solver
From A1 to A100, i got value from 1 to 100 (A1 will be value 1, A2 will be
value 2 and so on). how do i get excel solver to choose for me cells that can possibly add up to a value of 22? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using Excel Solver
would you expand?
how many cells? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using Excel Solver
Put 1 in each cell in B1:B100
In C1 enter =SUMPRODUCT(A1:A100,B1:B100) Solver: Target C1; Value 22 By changing B1:B100 Constraint B1:B100 binary Solve There can be many answers, Solver gives one that depends on initial state best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Kenneth" wrote in message ... From A1 to A100, i got value from 1 to 100 (A1 will be value 1, A2 will be value 2 and so on). how do i get excel solver to choose for me cells that can possibly add up to a value of 22? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using Excel Solver
There can be many answers, Solver gives one that depends on initial state
best wishes Just to mention...combination theory says there are 89 Solutions to this particular problem. -- Dana DeLouis "Bernard Liengme" wrote in message ... Put 1 in each cell in B1:B100 In C1 enter =SUMPRODUCT(A1:A100,B1:B100) Solver: Target C1; Value 22 By changing B1:B100 Constraint B1:B100 binary Solve There can be many answers, Solver gives one that depends on initial state best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Kenneth" wrote in message ... From A1 to A100, i got value from 1 to 100 (A1 will be value 1, A2 will be value 2 and so on). how do i get excel solver to choose for me cells that can possibly add up to a value of 22? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using Excel Solver
thanks a lot! (:
"Bernard Liengme" wrote: Put 1 in each cell in B1:B100 In C1 enter =SUMPRODUCT(A1:A100,B1:B100) Solver: Target C1; Value 22 By changing B1:B100 Constraint B1:B100 binary Solve There can be many answers, Solver gives one that depends on initial state best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Kenneth" wrote in message ... From A1 to A100, i got value from 1 to 100 (A1 will be value 1, A2 will be value 2 and so on). how do i get excel solver to choose for me cells that can possibly add up to a value of 22? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use Excel Solver? | Excel Discussion (Misc queries) | |||
| Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
| Excel: Solver | Excel Worksheet Functions | |||
| how to use solver in excel | New Users to Excel | |||
| How can I get the Solver Add-in in Excel 97? | Excel Discussion (Misc queries) | |||
Linear Mode
