How do I use Excel Solver (for an Iteration in a row) for several no.of times?

D

Deepak

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.
 

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

Copying Solver results of each iteration to a given location in a workbook 1
Interesting Solver problem (Solver encounters an error) 3
Using Solver in VBA for excel without cell references 1
Looking for more elegant code 4
How to use index and match function for determining the value? 1
Repeated calls to Solver.xla causing Excel problems 0
How do I use Excel to find an average of times? 1
counting cells in a row with color highlight 7

Top