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

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" <(E-Mail Removed)> wrote in message
news:e1e4cff0-aabc-4b16-a5ed-(E-Mail Removed)...
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

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" <(E-Mail Removed)> wrote in message
> news:e1e4cff0-aabc-4b16-a5ed-(E-Mail Removed)...
> 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
>
> .
>