{=TABLE(,G1)}

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Folks
Trying to fogure out this function. It is part of a book I am studying, "Excel Data Analysis and Business Modeling." It came of a disk provided with the book. The function used is {=Table(,G)} entered as an array formula. I can find work help on the function and if I try and edit the formula, F2, then CTRL+Shift+Enter (Array), I get this message, "That function is not valid." If I try and look the funtion up in using "Insert Function" tool, it does not exist. Analysis pack is installed as an add-in. Liike I mentioned, if I just try and edit the formula, it will not allow me to

Thanks Folks
 
I did get it to work, but I am ceratin what the parameters are that I am entering. The column input is empty and the row input is periods, I think. Is there any help in the knowledge base on this

Thanks
David
 
Knowledge base stuff, have not had a chance to read all articles
Microsoft Knowledge Base Article - 28285
282851 XL: How to Use Microsoft Excel Data Tables to Analyze Information in a Databas
282855 XL: How to Create and Use One-Input Data Tables in Microsoft Exce
282856 XL: How to Create and Use Two-Input Data Tables in Microsoft Exce
 
Back
Top