Array Formula Confusion

[Jim]

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

 

[Mike Middleton]

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



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

 

[ryguy7272]

It's a data table. See this for an explanation:
http://www.homeandlearn.co.uk/excel2007/excel2007s7p1.html

And here's a video for ya: