DROP Function. Deletes rows and columns from range of cells.(Microsoft Excel)
The DROP function is a new function added to Excel in September 2022 that deletes a portion of a cell range.
It is a function that is often used in combination with other functions rather than on its own.
Contents
How it works
=DROP(array,rows,columns)
| Name | Omission | Explanation |
|---|---|---|
| array | Required argument. Specify the target cell range. | |
| rows | Required argument. Specifies the number of lines to delete. Specify 0 for no deletion, or a negative number for deletion from the end. | |
| columns | 0 | Specifies the number of columns to delete. Specify 0 for no deletion, or a negative number for deletion from the end. |
Demonstrate
The first argument is the target cell range and the second argument is the number of rows to delete.
If the second argument is a negative number, it is removed from the tail.
The third argument is optional, but here you specify the number of columns to delete.
If no rows are to be deleted, the second argument can be zero or none, followed by a comma.
---
Links
Microsoft Excel Functions Lookup & Reference
Examples of Use
Formula to extract only rows with values.
TEXTSPLIT Function.
If there is a newline character at the end, the last line becomes an error line. The DROP function is used to deal with this problem.