I am working with a spreadsheet from another user and it contains a couple of
tables with an =TABLE(c12,c21) type formula. I am using 2007 and have
searched to see what this formula may have meant in an earlier version but
can not find anything? Can anyone help?

See Harlan Grove's post in:

http://groups.google.com/group/micro...roup%3A*Excel#
--
Gary''s Student - gsnu200787


"Excel User 123456" wrote:

I am working with a spreadsheet from another user and it contains a couple of
tables with an =TABLE(c12,c21) type formula. I am using 2007 and have
searched to see what this formula may have meant in an earlier version but
can not find anything? Can anyone help?

=TABLE(c12,c21) type formula.

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Excel User 123456" wrote:
I am working with a spreadsheet from another user and it contains a couple of
tables with an =TABLE(c12,c21) type formula. I am using 2007 and have
searched to see what this formula may have meant in an earlier version but
can not find anything? Can anyone help?