Forum Discussion
Finding the best combination of values using solver
Lost_inExcel I'm not entirely sure, without seeing what went wrong. If you could save and attach the file (or provide a screenshot), I could possibly offer something more concrete. What version of Excel are you using? The formulas I used will only work with Excel for MS365. This is what it looks like when I input $1 for all parts for Sup1:
Min Cost via Data Table
As long as you input any Row_ID with the lowest cost (1 thru 6) in cell F13, it should assign all 19 parts to Sup1.
Thank you very much! Calculation is good.
Had question if :
I artificially put $1/- for each part for Sup1, the by default, it does not assign 19 parts to supplier1.
Why would that be the case
Lost_inExcel I'm not entirely sure, without seeing what went wrong. If you could save and attach the file (or provide a screenshot), I could possibly offer something more concrete. What version of Excel are you using? The formulas I used will only work with Excel for MS365. This is what it looks like when I input $1 for all parts for Sup1:
Min Cost via Data Table
As long as you input any Row_ID with the lowest cost (1 thru 6) in cell F13, it should assign all 19 parts to Sup1.
Lost_inExcel Glad you were able to figure it out. 🙂 To help eliminate those potential errors/mistakes, I made a few small modifications to the file (see attached).
- It is very good. Thank you for the pointed arrow modification.
🙏👍
- Thank you, I confirmed your spreadsheet works perfectly in MSoffice365 laptop. So I must use Excel for MS365.