How to get Solver to target array rather than cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top