DROP function
The DROP function is one of the lookup and reference functions. It is used to drop rows or columns from array start or end.
Syntax
DROP(array, rows, [columns])
The DROP function has the following arguments:
| Argument | Description |
|---|---|
| array | Is used to set the array from which to drop rows or columns. |
| rows | Is used to set the number of rows to drop. A negative value drops from the end of the array. |
| columns | Is used to set the number of columns to drop. A negative value drops from the end of the array. |
Notes
Please note that this is an array formula. To learn more, please read the Insert array formulas article.
How to apply the DROP function.
Examples
The figure below displays the result returned by the DROP function.
