[RESOLVED] Table Question

[Mitch_s_s]

Just looking at a workbook from john walkenbachs book

there is a function in a cell i am unfamiliar with

the function is

{=TABLE(,C8)}

could someone help me out?

thanks

[RobDog888]

This may be what you are talking about. Its the Table method of the range object.

http://office.microsoft.com/client/h...e5GUU&respos=1

[Mitch_s_s]

Thanks Rob,

just looking now, i still dont get it though lol

[zaza]

OK, here's a run-thru:

Put the following in these cells:

A1: 1
A2: 1
B2-B11: 1-10
C1-L1: 1-10
B1: =A1+A2

Now select the range from B1 to L11 and go to Data -> Table. It will ask for a row and column input. Set Row Input to be A1 and Column Input to be A2.


Do you see what has happened? You have generated a table of values based on the result of the formula in cell B1 and using the row and column values as inputs. If you now change the formula in B1, you will change all the values in the table, but without loads of formulae.
Where this gets really powerful is if you have lots of other calculations in between your inputs and you final output formula. You can calculate at a stroke a vast number of possible outcomes to a complicated series of equations.


The {TABLE(A1,A2)} just tells you which cells are being changed to calculate the output in the upper-left corner of the table.


zaza

[Mitch_s_s]

nice one zaza

legend