Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I use the TABLE worksheet function?
How do I use the TABLE worksheet function?
|
#2
|
|||
|
|||
http://support.microsoft.com/default...b;en-us;282851
Jo wrote: How do I use the TABLE worksheet function? |
#3
|
|||
|
|||
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 -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Jo" wrote in message ... How do I use the TABLE worksheet function? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function to return the current Worksheet name? | Excel Worksheet Functions | |||
Excel 2003 worksheet name function? | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Display specific rows from table on other worksheet | Excel Discussion (Misc queries) | |||
mystery function called 'TABLE' | Excel Worksheet Functions |