Voci con l'etichetta :
Chiudi
Changelog
Chiudi
Voci con l'etichetta :
Chiudi
Provalo nel cloud

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.

DROP Function

Alla pagina precedente
Try now for free Try and make your decision No need to install anything
to see all the features in action