ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Solver with text (https://www.excelbanter.com/excel-worksheet-functions/226123-solver-text.html)

LiAD

Solver with text
 
Hi,

I need solver to calculate the order to make certain products A B C etc.
Based on other numerical data, production time, date etc I can figure out
when products should be started and finished. However I would like excel
solver to re-arrange the product list from A B C A B A B C to A A A B B B C
in order to minimise set-up time providing the products will be delivered on
time.

Is it possible for solver can do this product re-arrangement?


All times are GMT +1. The time now is 05:01 PM.

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