Need help with this function

[Guest]

I have been given an excel file that contains the following formula: {TABLE
(,B45)} i have never seen this formula before. Does anyone know how it works
and/or what it is used for?

 

[lgarcia]

Hi sara!

It can be an excel customized formula or a formula to get values fro
pivot tables.
Do you have tables within that workbook

 

[Aladin Akyurek]

See:

http://support.microsoft.com/default.aspx?scid=kb;en-us;282851

 

[Max]

... {TABLE (,B45)}

The above is a formula refering to a 1-variable data table.
It has to be set-up via clicking the Data > Table menu
(it *cannot* be typed in and entered like a "normal" array formula)

Type: 'data tables' in Excel's help for more info

There's also a 2-variable data table which reads
both row and column inputs to output what-if results

This link has a pdf file which covers the data-table topic
in some detail (watch the line wrap):
http://it.fuqua.duke.edu/public/2001XLDataTablesMonochrome.pdf

Try also: http://tinyurl.com/5b7uf
for a simple example set-up for a 1-variable
and a 2-variable data table