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 the trailing blank rows in the
cells.
Notes
- This function is intended for use in array formulas. You submit array formulas with special keyboard shortcuts. We recommend that you use the unconstrained keyboard shortcut Ctrl+Alt+Enter (on Windows) or Command+Option+Enter (on Mac) so Worksheets can use all the cells it needs for the results. For more information, see Reference: Array Formula Keyboard Shortcuts.