Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-12-2022, 05:14 PM
WAC WAC is offline Choose Second & Third best box size given dimensions Windows 10 Choose Second & Third best box size given dimensions Office 2019
Novice
Choose Second & Third best box size given dimensions
 
Join Date: Jan 2022
Posts: 1
WAC is on a distinguished road
Default 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!
Attached Files
File Type: xlsx Box Project.xlsx (10.1 KB, 10 views)
Reply With Quote
 

Tags
index match

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Userform dimensions suddenly exaggerated mark99k Word VBA 6 11-01-2018 11:09 PM
True 4:3 background dimensions a_gunslinger PowerPoint 1 11-28-2016 08:22 PM
Choose Second & Third best box size given dimensions Drawing room layouts with dimensions Jeff Fenerty Drawing and Graphics 4 01-01-2016 07:13 PM
Choose Second & Third best box size given dimensions Print business cards with exact dimensions mqdias PowerPoint 1 03-11-2013 06:38 AM
Choose Second & Third best box size given dimensions Page dimensions are changing in word 2003 OldFashionedOutlookUser Word 4 05-15-2012 02:44 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:29 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft