How do I use the TABLE worksheet function?

  • Thread starter Thread starter Guest
  • Start date Start date
Another couple of simpler, shorter examples, perhaps?

For an example set-up of a 2 variable data table which reads both row and
column inputs to output what-if results, try: http://tinyurl.com/d9gfv

For an example set-up of a one variable data table,
try: http://tinyurl.com/562dj

And you could also type: data tables
in Excel's help for more info

Note that although the TABLE function (e.g.: {=TABLE(,A1)} ) looks very much
like an array formula, it cannot just be entered as such. The construct of
the data table must be done / invoked via the Data > Table menu / steps
outlined in the examples
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Absolute References and worksheets 0
Editing an "IF" function across a worksheet/excel file 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
CONCATENATE & LOOKUP Functions 0
Excel Moving data to sheet2 from sheet1 0
Help with worksheet function 2
Using solver function in a locked (protected) worksheet 2
Help using the LARGE function "WITHOUT" using an array 14

Back
Top