Table feature in Data Menu

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Katie - 28 Mar 2008 22:17 GMT

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!

Reply to this Message

Alan - 28 Mar 2008 22:49 GMT

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.

>I have a workbook that uses a function called table(,cell).
>
[quoted text clipped - 5 lines]
>
> Please help!

Reply to this Message

Katie - 28 Mar 2008 23:33 GMT

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

> That sounds like a UDF or User Defined Function, ie something that someone
> has written, not a built in Excel function.
[quoted text clipped - 14 lines]
> >
> > Please help!

Reply to this Message

Alan - 29 Mar 2008 02:57 GMT

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.

> No. There is information about the table feature. It is something that
> is
[quoted text clipped - 32 lines]
>> >
>> > Please help!

Reply to this Message

Alan - 29 Mar 2008 03:08 GMT

'I have a workbook that uses a function called table(,cell).'
Forgot to mention, 'cell' is probably a named range.

> 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
[quoted text clipped - 50 lines]
>>> >
>>> > Please help!

Reply to this Message

Max - 29 Mar 2008 22:30 GMT

>I have a workbook that uses a function called table(,cell).
> .. how that feature is used and how the table was set up.

{=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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> No. There is information about the table feature. It is something that is
> part of Excel, but does not work like regular functions.
[quoted text clipped - 18 lines]
> > Regards,
> > Alan.

> > > 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!

Reply to this Message

Mike Middleton - 29 Mar 2008 03:03 GMT

Katie -

For some step-by-step examples of the Data Table feature, see Chapter 2,
Sensitivity Analysis Using Excel, available from the Chapters page at
http://www.treeplan.com

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

>I have a workbook that uses a function called table(,cell).
>
[quoted text clipped - 5 lines]
>
> Please help!

Reply to this Message