formula {=TABLE(G13;)}
 

I found the formula {=TABLE(G13;)} in a worksheet, and I would like to know
its function. I've checked in Visual Basic and did not find any macro under
that name...

formula {=TABLE(G13;)}
 

It's an array formula, as indicated by the squiggly brackets { }

Array formulas are entered by pressing CTRL+SHIFT+ENTER at the same time, as
opposed to the conventional way of just hitting ENTER.

Array formulas essentially perform multiple calculations across a range.

I think the TABLE function is used for data tables. See this for more info
about data tables: http://www.ozgrid.com/Excel/data-tables.htm

Dave
--
Brevity is the soul of wit.


"Guylaine" wrote:

I found the formula {=TABLE(G13;)} in a worksheet, and I would like to know
its function. I've checked in Visual Basic and did not find any macro under
that name...

formula {=TABLE(G13;)}
 

It's put in by Excel (you can't enter it) when you use the Data/Table
command


"Guylaine" wrote in message
...
I found the formula {=TABLE(G13;)} in a worksheet, and I would like to
know
its function. I've checked in Visual Basic and did not find any macro
under
that name...