Need help with this function

S

Sara

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?
 
L

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
 
M

Max

... {TABLE (,B45)}
Click to expand...

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
 
Top