TABLE Function/Array HELP!!!

[chris]

{=TABLE(,B13)}
Can anyone tell me what this array function is doing and how it
works? Any help is greatly appreciated!

 

[Niek Otten]

It is not an array function. The cell is part of a Data Table.
You create Data Tables (in Excel 2003 and before) in the Data>Table menu command. In Excel 2007 it is in the Data tab, Data Tools
block, What-if analysis drop down.

Data tables should not be confused with Tables in Excel 2007.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| {=TABLE(,B13)}
| Can anyone tell me what this array function is doing and how it
| works? Any help is greatly appreciated!

 

[chris]

Thank you, that's the answer!

 

[Mike Middleton]

Niek Otten -

I usually describe the TABLE function as a "special" array function that can
only be entered using the menu command.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel