JMB wrote:
Won't that throw an error if the first row or column is deleted (assuming the
table does not start in cell A1)?
"Bob Phillips" wrote:
=FACT(ROW(A1))
ROW(A1) is not an idiom one would choose if one is concerned with
robustness.
=FACT(ROWS($1:1))
entered in A1, would be robust against inserting rows/columns before the
formula cell and against deleting the first formula row.
|