View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
smandula smandula is offline
external usenet poster
 
Posts: 116
Default Solver with limit

Is it possible to limit the numbers of interations Solver
uses to sum a column of numbers. Currently, Solver
summerizes a given column to the specified total (say 198)
using 8 numbers. Could Solver be limited to Summing the
same column to 6 numbers. I have tryed to randomized (by changing
order)
of the numbers in the column, but it does not work. Any ideas would be
appreciated.

With Thanks