Array / Function HELP!!!

[chris]

What does the following array function accomplish? How does it work?

{=TABLE(,B13)}

I've searched the groups and the MS website but can't find anything.

Any help is greatly appreciated!

 

[ShaneDevenshire]

H Chris,

These are the functions that are employeed by Excel when you make a Data,
Table. You can't enter them manually.
{=TABLE(,B13)}
The means that this is a one variable data table, with the layout of the
changing variable values in a column and the one being used by the default
formula being located in cell B13.
You can get a little info on this by typing Data Table into the help system.
To the best of my knowledge, people tend not to use this feature, for one
thing you can duplicate its functionality with more explicit formulas or with
a pivot table.

 

[chris]

Perfect, thank you!