DROP
Excludes a specified number of rows or columns from the start or end of an array
Syntax
DROP(array, rows, [columns])
Parameters
- array: Required. The array from which to drop rows or columns
- rows: Required. The number of rows to drop (negative drops from end)
- columns: Optional. The number of columns to drop (negative drops from end)
Example
=DROP(A1:D5, 2, 1)