Forum Discussion
FarshidKaviani
Jul 12, 2020Copper Contributor
How to find best combinations in Excel
Hi There, I have a complex problem that can be solved by nested loops, which means programming skills which I am not equipped with at this point, but I thought you might have a suggestion on how to ...
TheAntony
Jul 14, 2020Iron Contributor
FarshidKaviani , You can set the constraints as ranges instead of individual cells. See example. Hope that helps.
FarshidKaviani
Jul 14, 2020Copper Contributor
TheAntony Thank you so much. That works perfectly!!!
- TheAntonyJul 15, 2020Iron Contributor
FarshidKaviani , Glad it helped!