How to get Solver to target array rather than cell?

[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?

 

[Guest]

In order to do that you need to order the solver suite from the company that
produces the standard excel solver tool:
http://www.solver.com/exceluse.htm#Premium Solver Platform

Dave

 

[Guest]

Thanks a lot. I'll try the test download- Harry Hall

 

[Tushar Mehta]

Add a constraint that indicates the row cells should equal 100%, i.e.,
1. For example, if you want A11 to equal 100%, add the constraint
A11=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