Forum Discussion
Need Excel Help for Finding Number Combinations
I am trying to write or find a formula for the following: I have a large column (A) of numbers as currency to 2 decimal places. I have larger numbers as currency in smaller quantities in another col...
This sounds like the Knapsack problem: https://techcommunity.microsoft.com/t5/excel/solving-an-0-1-knapsack-problem-with-lambda/m-p/3782575#M186734
I recommend reading that thread and using some of those formulas/approaches. I think giving you the reference to that is better than trying to pick one because there is a lot of unknowns here including how many options you have and if/or how well those solutions will work in your case.
I recommend reading that thread and using some of those formulas/approaches. I think giving you the reference to that is better than trying to pick one because there is a lot of unknowns here including how many options you have and if/or how well those solutions will work in your case.
Thank you.