I don't know how to solve for row 2. For others, here is how to do it.
I note threads where I participate. As such, I see that you cross-posted this and it had no response either.
e.g. For row 3:
'http://www.excelguru.ca/forums/showthread.php?7156-solver
'http://www.excelforum.com/showthread.php?t=1167981
'https://msdn.microsoft.com/en-us/library/office/ff838657.aspx
'Tools > References > Solver 'Must enable Solver add-in first, then add reference.
Sub mSolver()
SolverReset
SolverOk SetCell:="$P$3", MaxMinVal:=1, ValueOf:=0, ByChange:="$L$3", Engine:=1 _
, EngineDesc:="GRG Nonlinear"
'Relation=2=equals
SolverAdd CellRef:="$P$3", Relation:=2, FormulaText:="$K$3"
' Do not display the Solver Results dialog box.
SolverSolve UserFinish:=False
End Sub
Bookmarks