Thread: TABLE function?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default TABLE function?

Hi Mike,

This is an array function created by Excel when the command Data, Table is
used. You should look up Data Tables in the help system for a little more
info. These days we generally use regular formulas, or pivot tables to do
similar analysis. By the way you can't enter or edit the TABLE function.

--
Cheers,
Shane Devenshire


"Mike C" wrote:

I have this model that does what-if scenarios and there is a formula written:
{=TABLE(,A1)}.

Can anyone tell me what function this is performing?

More info: the model has 3 scenarios (let's call them 1, 2,3). When 1 is
selected, the model displays the results for scenario 1, etc. However on a
separate sheet, a summary of each of the scenarios is grouped by using the
above formula.

Any ideas?