I have an excel s/s and several cells contain the same formula,
"{=TABLE(E15,E9)}". How can i find out what TABLE(E15,E9) is doing? I
think it's performing some type of calculation. Is it a table array?

any help is greatly appreciated.


--
efarhat
------------------------------------------------------------------------
efarhat's Profile: http://www.excelforum.com/member.php...o&userid=26595
View this thread: http://www.excelforum.com/showthread...hreadid=398705

TABLE is not a standard Excel worksheet function as far as I know. It
may be a user-defined function that one of your fellow employees
created.
If you are confident in Excel programming, check your add-ins.

Szalapski


--
TommySzalapski
------------------------------------------------------------------------
TommySzalapski's Profile: http://www.excelforum.com/member.php...o&userid=25561
View this thread: http://www.excelforum.com/showthread...hreadid=398705

Your message header describes it perfectly - it's a 2 variable data table,
created through Data->Table. The first reference is the cell that the
values down the left side substitute for, the second reference is for the
values accross the top of the table
The formula at the intersection of those two ranges is reflected in the
table


"efarhat" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> I have an excel s/s and several cells contain the same formula,
> "{=TABLE(E15,E9)}". How can i find out what TABLE(E15,E9) is doing? I
> think it's performing some type of calculation. Is it a table array?
>
> any help is greatly appreciated.
>
>
> --
> efarhat
> ------------------------------------------------------------------------
> efarhat's Profile:
> http://www.excelforum.com/member.php...o&userid=26595
> View this thread: http://www.excelforum.com/showthread...hreadid=398705
>

Max has posted a sample in this link:
http://tinyurl.com/562dj

You get it via Data|Table (it's not something you can type in).



efarhat wrote:
>
> I have an excel s/s and several cells contain the same formula,
> "{=TABLE(E15,E9)}". How can i find out what TABLE(E15,E9) is doing? I
> think it's performing some type of calculation. Is it a table array?
>
> any help is greatly appreciated.
>
> --
> efarhat
> ------------------------------------------------------------------------
> efarhat's Profile: http://www.excelforum.com/member.php...o&userid=26595
> View this thread: http://www.excelforum.com/showthread...hreadid=398705

--

Dave Peterson