ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Anyone know how to display iterations from solver? (https://www.excelbanter.com/excel-worksheet-functions/115569-anyone-know-how-display-iterations-solver.html)

Melic

Anyone know how to display iterations from solver?
 
I checked the box to show them, but they don't show. I want to be able to
display them in the work sheet.

Bernard Liengme

Anyone know how to display iterations from solver?
 
With the Option "show Iterations" set, the results show in the status bar at
bottom of Excel window.
To get a cell-by-cell report for each iteration would need some fancy VBA -
if it is possible
Try to get help from www.solver.com
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Melic" wrote in message
...
I checked the box to show them, but they don't show. I want to be able to
display them in the work sheet.





All times are GMT +1. The time now is 06:53 AM.

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