Need help with this function
 

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?

Need help with this function
 

Hi sara!

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


--
lgarcia
------------------------------------------------------------------------
lgarcia's Profile: http://www.excelforum.com/member.php...fo&userid=9520
View this thread: http://www.excelforum.com/showthread...hreadid=480226

Need help with this function
 

See:

http://support.microsoft.com/default...b;en-us;282851

Sara wrote:
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?

Need help with this function
 

"Sara" wrote
... {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/2001...Monochrome.pdf

Try also: http://tinyurl.com/5b7uf
for a simple example set-up for a 1-variable
and a 2-variable data table
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--