array formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i'm looking at a formula: {table(,b2)} and don't know what it does (know it's
array formula but that's about it). can anyone enlighten me, thanks!
 
if there are several cells with this table function in a column, the cells
just to the left are variables used to replace the B2 variable in a formula
just above the cells with table
if the cells with the table function are in a row the values above are used
to replace a B2 variable in a function just to the left of the cells
If there were a block of cells with two variables listed the formula would
be in the cell just to the left and just above the block, with the column to
the left replacing the first variable listed and the row above replacing the
second variable.
 
Back
Top