View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tushar Mehta Tushar Mehta is offline
external usenet poster
 
Posts: 126
Default How to get Solver to target array rather than cell?

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?