Add a constraint that indicates the row cells should equal 100%, i.e.,
1. For example, if you want A1:D1 to equal 100%, add the constraint
A1:D1=1
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005
In article , h.2
@discussions.microsoft.com says...
I want to get an output row vector to have 100(%) in each column, by
modifying the inputs in Solver. I can make it work for one column at atime
but cant do them all at once. Is there a "solver" method for arrays as well
as single target cells?