Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |