Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I use Excel Solver (for an Iteration in a row) for several no.of times?
X Y Z
1 5 3 5 2 ? 4 3 3 ? 6 2 ........................ ........................ Using solver in excel 2007, i did an iteration for row1 alone, where the target cell is Z1 (containing formula) and by changing cell X1 (Value assumed) subjected to constraint X1=Z1...After solving, i got certain value (here it is "5"). The problem is Every time, am using solver option "n" no. of times for each row. Since it consumes lot of time, How can i use the solver to repeat (or automate) the above calculation for several number of rows?? Any Help is greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Having Solver Call a macro for each iteration | Excel Discussion (Misc queries) | |||
Excel Iteration Program | Excel Discussion (Misc queries) | |||
Iteration problem (Excel 2002) | Excel Worksheet Functions | |||
Help requested for Excel Iteration problem | Excel Discussion (Misc queries) | |||
How do I resolve complex iteration problems in Excel? | Excel Discussion (Misc queries) |