FUNCTION CATALOGUE / LOOKUP & REFERENCE
DROP Excel function
Removes rows or columns from an array result.
Correct sentence to use
Remove the first [number] rows from [array].
Modify this query in PlainFormula →Example formula
=DROP(A2:D100,1)
Drops rows or columns from an array.
Syntax
DROP(array, rows, [columns])
Argument signature: array, rows, [columns]
Availability note
Available in supported Microsoft 365 / newer Excel versions; verify the exact release and platform.