Excel - 'TABLE' array function

Asked By JB201 on 21-Aug-08 11:55 AM
Hi

I have come across a spreadsheet with the following formula in it

{=TABLE(J88,G88)}

i know that this is some sort of array formula because of the {} brackets,
however i cannot get this to work outside the file i have been sent.

there is no Help about this in Excel & when i try to Ctrl+Shift+Enter into a
new cell, looking up the same cell references, it fails to work, saying "This
formula is not valid"?

Is 'TABLE' a bespoke formula of some kind?

Do i need some special Add-In enabled? I have both the Analysis Paks turned
on?

Any help gratfeully recieved, let me know if you need anymore info

cheers

jb




JB201 replied on 21-Aug-08 12:03 PM
Hi

I have just found a very good response to a similar question from Max in
Singapore,

thank you Max!!!
demechani replied on 21-Aug-08 09:56 PM
You're welcome <g> !
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400 Files:358 Subscribers:55
xdemechanik
---
ScoobyDo replied on 05-Oct-08 10:26 PM
So what was the answer?
demechani replied on 05-Oct-08 11:44 PM
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
---