| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Excel calculate populate table using row/column values & calc's on other sheet?
I've attached a trimmed down version of the file... NUM1 and NUM2 are in cells C8 (press speed) and C9 (panel length) of MAIN sheet while RESULT is in F39 (Total wait time before...). The table I want to build is on the TABLE sheet. After tracing the precedents back from F39 I suppose I could cram all that into one formaula that I could replicate in the table but I know it would take me forever to get it right or I could manually do each combination and key in the values. Just wondering if there's an easier way. +-------------------------------------------------------------------+ |Filename: Table help for ExcelTip.zip | |Download: http://www.excelforum.com/attachment.php?postid=4269 | +-------------------------------------------------------------------+ -- wildswing ------------------------------------------------------------------------ wildswing's Profile: http://www.excelforum.com/member.php...o&userid=30853 View this thread: http://www.excelforum.com/showthread...hreadid=505213 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| In Excel, how do you make one whole sheet equal to another. | Excel Discussion (Misc queries) | |||
| Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
| How to convert the table in word to excel sheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
