ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I use the TABLE worksheet function? (https://www.excelbanter.com/excel-worksheet-functions/33544-how-do-i-use-table-worksheet-function.html)

Jo

How do I use the TABLE worksheet function?
 
How do I use the TABLE worksheet function?

Aladin Akyurek

http://support.microsoft.com/default...b;en-us;282851

Jo wrote:
How do I use the TABLE worksheet function?


Max

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?





All times are GMT +1. The time now is 04:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com