Table feature in Data Menu

  • Thread starter Thread starter Katie
  • Start date Start date
K

Katie

I have a workbook that uses a function called table(,cell).

I need to undertstand how that feature is used and how the table was set up.
Is there a way to reverse engineer the existing workbook? Unlike other
functions, the predecessors are not neatly indicated in the arguement list.

Please help!
 
That sounds like a UDF or User Defined Function, ie something that someone
has written, not a built in Excel function.
Try hitting Alt and F11 together to open the VB editor and look in Sheet1,
Sheet2, This Workbook etc on the left.
Look for something that starts 'Function Table () or similar.
Copy and paste the code here and maybe someone will be able to help you with
it,
Regards,
Alan.
 
No. There is information about the table feature. It is something that is
part of Excel, but does not work like regular functions.

I did find some sites, but don't understand enough to figure out how the
worksheet was put together originally.

here is a site I found that describes the table feature and function, if
that helps anyone understand what I want to find out.

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


Katie
 
Yes, your right, it is a built in function. It's in the 'Data' toolbar. I've
been using Excel in a reasonably advanced way for years and I've never used
it, and I must confess ever heard of it!
There's an explanation of how it works here:-
http://www.homeandlearn.co.uk/ME/mes8p1.html
I followed the tutorial and it does work, but I don't really think I'd ever
use it, it seems more trouble than it's worth. You may have trouble back
tracking your sheet however, I presume it's something that you've inherited.
There doesn't seem to be any way of seeing what the table refers to other
than checking each cell to see if it has a table reference in it, (like
{=TABLE(,B3)}). Hitting Ctrl and ' together will toggle the formulas on the
sheet (' is the key just below the Escape key), that may help,
Good Luck!
Regards,
Alan.
 
'I have a workbook that uses a function called table(,cell).'
Forgot to mention, 'cell' is probably a named range.
Alan.
 
I have a workbook that uses a function called table(,cell).
.. how that feature is used and how the table was set up.
Click to expand...

{=TABLE(,Cell ref)}

Its a "one variable data table" which is used for sensitivity analysis.
Albeit it looks like an array formula, it's not. The table needs to be set up
via the menu command: Data > Table ..

You could try typing in Excel's help: one variable data table
for more information

Try also the 2* samples on data table in my archives:
*one variable, 2 variable

One variable data table example.xls
http://savefile.com/files/1007074

2 variable data table example.xls
http://savefile.com/files/46276


---
 
Back
Top