Compare sizes of different boxes and pick the correct size to put another box in to!
Hello,
I have a list of shipping boxes complete with their dimension. I also have a list of finished product packed in their own boxes! I have to chose which shipping box is the most sensible to use for each product - assuming one product per shipping box. It is easy enough choice to make manually - but I have LOTS to do and so want to know if Excel can make the decision for me! I've attached an example of the spreadsheet - I can organise columns by size and even chose max; min and median but I can't then figure out how to make Excel chose the right box! The products can be packed in any orientation.
Any help would be gratefully received!
|