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.

Alla pagina precedente