DROP
Excludes a specified number of rows or columns from the start or end of an array.
Lookup & ReferenceDynamic Arrays & LAMBDALookup & Matching EssentialsModern Excel Functions
What it does
Removes rows or columns from an array (start or end).
Syntax
DROP(array, rows, [columns])
Arguments
array(array) — The source array.rows(number) — Number of rows to drop (positive=start, negative=end).columns(number) — Number of columns to drop (optional).
Examples
Remove Header
Drop the first row.
FORMULA
=DROP(A1:A4, 1)
RESULT
[10; 20; 30]
SAMPLE DATA
| A | |
|---|---|
| 1 | Header |
| 2 | 10 |
| 3 | 20 |
| 4 | 30 |