consecutive numbers
The last one I understand having looked what the ROWS function does however
why is this better than using the ROW() function?
Thanks
"Harlan Grove" wrote:
"T. Valko" wrote...
Another one:
=ROWS($1:1)*$A$4
....
Better to start with a single cell, e.g., if the formula were entered
in cell X99,
X99:
=ROWS(X$99:X99)*$A$4
since any entries/changes anywhere in row 1 would cause your formula
to recalc.
|