Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I have managed to use solver to find a solution to a problem, does anyone know of a way to use this solution repetively like a fill down. I need to use solver on about 1000 rows of data to find a solution, and I need the target cell, changing cells and contraints to advance to the next row, ie for solution: 1st row: target cell = $A1, Changing cell = $B1, contraint $A1 = $C1 2nd row: target cell = $A2, Changing cell = $B2, contraint $A2 = $C2 3rd row: target cell = $A3, Changing cell = $B3, contraint $A3 = $C3 Thanks, Shalini |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Solver and dynamic ranges | Excel Worksheet Functions | |||
Solver Problems | Excel Worksheet Functions | |||
question on excel Solver | Excel Worksheet Functions | |||
Excel: Solver | Excel Worksheet Functions | |||
solver constraint | Excel Worksheet Functions |