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?

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#P...ver%20Platform

Dave
--
Brevity is the soul of wit.


"h.2" wrote:

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?

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

"Dave F" wrote:

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#P...ver%20Platform

Dave
--
Brevity is the soul of wit.


"h.2" wrote:

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

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?