Matthew has attended:
Excel Advanced course
Table array
can anyone explain difference between the 1 and 2 way tables?
RE: table array
Hi Matthew. Essentially, a one-way table has one input value which you change which then impacts on the value in any number of other cells. One the other hand, a two-way table involves changing values in two cells and those combining through a formula to provide one value. There are some interesting examples in this document:
http://www.doc.gold.ac.uk/ ~mas01rmz/331/Labs/lab1.doc
Hope this helps,
Anthony