DATA > TABLE -- 2 variable data tables?

  • Thread starter Thread starter efarhat
  • Start date Start date
E

efarhat

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.
 
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
 
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
 
Back
Top