Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

TABLE worksheet function

70 views
Skip to first unread message

Anjan

unread,
Jan 7, 2004, 10:33:10 AM1/7/04
to
Does anyone know how to use the TABLE function in Excel.
Basically I am trying to do a what-if scenario to see
values of a dependent variable based on changes in the
independent variable, all based on a formula. Any help is
much appreciated. Thanks. Anjan

Paul

unread,
Jan 7, 2004, 10:48:11 AM1/7/04
to
"Anjan" <anon...@discussions.microsoft.com> wrote in message
news:005d01c3d533$8e1b7b80$a101...@phx.gbl...

I was not aware that Excel has a TABLE worksheet function. What version are
you using? What does Help say if you type in "TABLE"?


Peo Sjoblom

unread,
Jan 7, 2004, 11:46:43 AM1/7/04
to
I suppose he means Data>Table

--

Regards,

Peo Sjoblom


"Paul" <none> wrote in message news:OCxZrWT1...@TK2MSFTNGP11.phx.gbl...

Anjan

unread,
Jan 7, 2004, 11:48:53 AM1/7/04
to
Paul - You are right. Excel help does not come up with
anything when querying for this function. I am using Excel
2000 currently, but I have seen this function used in some
spreadsheets I've come accross. Its just that the usage
does not clarify the functionality. Thanks.

>.
>

Peo Sjoblom

unread,
Jan 7, 2004, 11:55:14 AM1/7/04
to
If you look at Data in help there are references to Data>Table and how to
use it

--

Regards,

Peo Sjoblom


"Peo Sjoblom" <ter...@mvp.org> wrote in message
news:OR3rX3T1...@tk2msftngp13.phx.gbl...

Paul

unread,
Jan 7, 2004, 12:06:39 PM1/7/04
to
If we are really talking of a worksheet function (rather than Data > Table
as Peo Sjoblom has suggested) then it must be a user-defined function, so
you would have to refer to the author for details.

"Anjan" <anon...@discussions.microsoft.com> wrote in message

news:009001c3d53e$21f09750$a301...@phx.gbl...

Harlan Grove

unread,
Jan 7, 2004, 2:24:47 PM1/7/04
to
"Paul" wrote...

>If we are really talking of a worksheet function (rather than Data > Table
>as Peo Sjoblom has suggested) then it must be a user-defined function, so
>you would have to refer to the author for details.

Peo is correct. TABLE (or any variation involving different case of any of its
letters) can't be used as a UDF name. Try it.

TABLE *appears* to be a function, but it is in fact Excel's mechanism for
implementing Data > Table. Since Excel provides automatic recalculation options
including and excluding tables (and always has), it seems (proof would require
reading Microsoft design specs for Excel, if there are any) that Microsoft used
something that looked like a worksheet function to do this. However, TABLE is
*NOT* a worksheet function in the sense that users may type it into formulas in
any range. *ONLY* the Data > Table menu command (or macro equivalents) can
'enter' it into ranges, and it's *ALL* that can appear in such 'formulas'.

--
To top-post is human, to bottom-post and snip is sublime.

0 new messages