ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Solver with limit (https://www.excelbanter.com/excel-programming/383871-solver-limit.html)

smandula

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



All times are GMT +1. The time now is 11:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com