TRIMROWS
Description
Removes trailing blank rows from a range, when the data is a result of an unconstrained array formula.
Syntax
TRIMROWS(
range
) - range: The range to trim.
Example
When you use an array formula such as =SampleWorkerData!A:C, which contains an unconstrained column reference, the formula returns blanks in each cell below the cells containing data in columns A, B, and C.
The formula =TRIMROWS(SampleWorkerData!A:C) removes trailing rows containing blanks in the cells.
Notes
- This function is intended for use in array formulas.