Forum Discussion
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 Thank you so much for your help. I managed to solve the problem using your method but since the standard span of elements covers a wide range so I do appreciate any other suggestions that can take a range of numbers as standard element sizes.
I appreciate your time and help!
Regards,
Farshid
FarshidKaviani , You can set the constraints as ranges instead of individual cells. See example. Hope that helps.
TheAntony Thank you so much. That works perfectly!!!
FarshidKaviani , Glad it helped!