Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 11-11-2013, 09:09 AM
BobBridges's Avatar
BobBridges BobBridges is offline finding data from different tables based on header Windows 7 64bit finding data from different tables based on header Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Ok, it's as I suspected and I misunderstood at first. I was thinking you had six tables, but you have ten, two for each door.

Now, your workbook has to determine which of the ten tables to use. One choice is easy; the user must somehow indicate whether his figures are in inches or centimeters. But the other I'm not sure of. He must give two figures, I gather, and indicate whether they are height, width or length; and your logic must take those two figures, figure out which door(s) they'll fit through, and then figure out the maximum quantity of the missing dimension that will fit through one of those doors. For example: The user has a package that is 1800cm high and 3000cm long. Three of the doors won't take that package at all; but there is one door that can take it if it's no wider than 400 cm, and another than can take it even if it's as much as 1100 cm. So the user enters "cm", 1800, "height", "3000" and "length", and the worksheet gives 1100 as the answer. Like that?

But if so, I'm having trouble picturing how it is that you can have just one table for each door (or rather two, depending on in/cm). Could you let me have a look at the tables for two of the doors, just so I can see how this works?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding sub-sets of data in worksheets Rudi Excel 3 01-28-2013 06:13 AM
finding data from different tables based on header Creating formula based on if data is correct in cell MattMurdock Excel 1 08-06-2012 03:11 AM
Calculations based off of unsorted data custermd Excel 1 05-04-2012 08:12 AM
Finding the difference of two dates based on criterion. aligahk06 Excel 0 04-27-2010 12:12 AM
finding data from different tables based on header Finding the complements between the two data sets psenku Excel 2 08-17-2009 11:15 PM

Other Forums: Access Forums

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