Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array Formula Confusion
Does anyone understand this array function?
{=TABLE(,H2)} Here's what I do know: 1) It doesn't seem to refer to any named ranges. 2) It doesn't seem to be a user-defined function. HELP! Thanks, Jim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array Formula Confusion
Jim -
It's a very special array function that can be entered only by using ribbon or menu commands. Before using it, you must set up and select a range on a worksheet. In Excel 2003 and earlier, choose Data Table. In Excel 2007 and 2010, choose Data (Data Tools) What-If Analysis Data Table. For some examples of its use, see the "Sensitivity Analysis Using Excel" PDF file, available from the Chapters web page at http://www.TreePlan.com. - Mike http://www.MikeMiddleton.com "Jim" wrote in message ... Does anyone understand this array function? {=TABLE(,H2)} Here's what I do know: 1) It doesn't seem to refer to any named ranges. 2) It doesn't seem to be a user-defined function. HELP! Thanks, Jim |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array Formula Confusion
It's a data table. See this for an explanation:
http://www.homeandlearn.co.uk/excel2...l2007s7p1.html And here's a video for ya: http://www.youtube.com/watch?v=qWLHJ4dDUoo -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Mike Middleton" wrote: Jim - It's a very special array function that can be entered only by using ribbon or menu commands. Before using it, you must set up and select a range on a worksheet. In Excel 2003 and earlier, choose Data Table. In Excel 2007 and 2010, choose Data (Data Tools) What-If Analysis Data Table. For some examples of its use, see the "Sensitivity Analysis Using Excel" PDF file, available from the Chapters web page at http://www.TreePlan.com. - Mike http://www.MikeMiddleton.com "Jim" wrote in message ... Does anyone understand this array function? {=TABLE(,H2)} Here's what I do know: 1) It doesn't seem to refer to any named ranges. 2) It doesn't seem to be a user-defined function. HELP! Thanks, Jim . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Formula confusion | Excel Discussion (Misc queries) | |||
Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
Formula confusion | Excel Worksheet Functions | |||
Formula Confusion | Excel Discussion (Misc queries) | |||
Tricky array formula issue - Using array formula on one cell, then autofilling down a range | Excel Programming |