|
Information Functions
Additional information functions:
HASFORMULA2 - returns true if the cell contains a formula
COUNTROWS2 and COUNTCOLS2 count the number of rows or columns from a referenced cell to the last visible non-empty cell in the row or column.
COUNTCONTIGROWS2 and COUNTCONTIGCOLS2 count the number of rows or columns from a referenced cell to before the next visible empty cell.
COUNTUSEDROWS2 and COUNTUSEDCOLS2 count the number of rows or columns from a referenced cell to the last cell in the used range.
CALCSEQCOUNTREF, CALCSEQCOUNTSET, CALCSEQCOUNTVOL simplify the tracing of Excel’s calculation sequence and determining if a function is volatile.
|
