- Document Solutions for Excel, .NET Edition Overview
- Key Features
- Getting Started
- Features
- Templates
-
Formula Reference
- Add-in and Automation Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
-
Lookup and Reference Functions
- ADDRESS
- AREAS
- CHOOSE
- CHOOSECOLS
- CHOOSEROWS
- COLUMN
- COLUMNS
- DROP
- EXPAND
- FILTER
- FORMULATEXT
- GETPIVOTDATA
- GROUPBY
- HLOOKUP
- HSTACK
- HYPERLINK
- IMAGE
- INDEX
- INDIRECT
- LOOKUP
- MATCH
- OFFSET
- PIVOTBY
- ROW
- ROWS
- SINGLE
- SORT
- SORTBY
- TAKE
- TOCOL
- TOROW
- TRANSPOSE
- TRIMRANGE
- UNIQUE
- VLOOKUP
- VSTACK
- WRAPCOLS
- WRAPROWS
- XLOOKUP
- XMATCH
- Math and Trigonometry Functions
- Statistical Functions
- Text Functions
- Web Functions
- File Operations
- Document Solutions Data Viewer
- API Reference
- Release Notes
DROP
The function excludes a specified number of rows or columns from the start or end of an array. You might find this function useful to remove headers and footers in a worksheet report to return only the data.
Note: DROP is a dynamic array formula, and you need to enable the dynamic array feature in the Workbook.
Syntax
DROP(array, rows, [columns])
Arguments
The function has the following arguments:
Argument | Description |
|---|---|
array | [Required] Refers to the array from which to drop rows or columns. |
rows | [Required] Refers to the number of rows to drop. A negative value drops from the end of the array. |
columns | [Optional] Refers to the number of columns to exclude. A negative value drops from the end of the array. |
Remarks
The function returns a #CALC! error to indicate an empty array when either of the row or column is 0.
Examples
