Choose Second & Third best box size given dimensions
Hi there!
Using the attached as a guide, I have a list of products and their dimensions and a list of my boxes and their dimensions.
I have a formula in place to get the most efficient box size to meet product dimensions.
I'm struggling to create a formula that'll give me the second and third best box choice. Ultimately I'd like to use this to optimize the number of boxes I keep in stock.
Thank you in advance!
|