Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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, 8 views)
Reply With Quote
Reply

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 01:36 AM.


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