Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 01-11-2018, 08:23 AM
NBVC's Avatar
NBVC NBVC is offline Compare sizes of different boxes and pick the correct size to put another box in to! Windows 10 Compare sizes of different boxes and pick the correct size to put another box in to! Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

I was afraid you were going to follow up with that question

Ok first insert a column for volume in column E and enter volumn formula:
Code:
=Product(B2:D2)
, remove spaces around the colon and then copied down

Then try this Array* formula:

Assuming your inputs have shifted over a column, now in K2:

Code:
=INDEX($A$2:$A$8,MATCH(1,($B$2:$B$8>=G2)*($C$2:$C$8>=H2)*($D$2:$D$8>=I2)*($E$2:$E$8=(MIN(IF(($B$2:$B$8>=G2)*($C$2:$C$8>=H2)*($D$2:$D$8>=I2),$E$2:$E$8)))),0))


*This formula must be confirmed with CTRL+SHIFT+ENTER not just ENTER before copying down.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare sizes of different boxes and pick the correct size to put another box in to! Word template: fixed size text boxes apophis Word 8 10-12-2015 01:48 AM
Compare sizes of different boxes and pick the correct size to put another box in to! How to correct the different font sizes of bullets in Word 2007 Mac265 Word 4 01-23-2015 11:27 AM
Pick up Style tool (eye dropper) ParreDL Word 7 03-20-2012 06:40 AM
Font size in dialog boxes nannycheryl Word 0 07-10-2010 09:26 AM
Compare sizes of different boxes and pick the correct size to put another box in to! Pick up data from Word documenta jmarin Excel 1 12-05-2008 02:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:47 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