View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 'TABLE' array function

So what was the answer?

{=TABLE(J88,G88)}


That's in a 2 variable data table, which is used to quickly produce
what-if-tables based on 2 variables, in sensitivity analysis. And albeit it
looks very much like an array formula, it cannot be entered as such. It has
to be set-up via the menu command: Data Table.

Try typing in Excel's help: two variable data table
for more information

Try also the 2* samples on data table in my archives:
*one variable, 2 variable

One variable data table example.xls
http://savefile.com/files/1007074

2 variable data table example.xls
http://savefile.com/files/46276

The samples contain the construct steps
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
---