- Formula Reference
- Contacting Us
- Getting Technical Support
- Formula Overview
-
Formula Functions
- Functions A to C
-
Functions D to G
- DATE
- DATEDIF
- DATEVALUE
- DAVERAGE
- DAY
- DAYS
- DAYS360
- DB
- DBCS
- DCOUNT
- DCOUNTA
- DDB
- DEC2BIN
- DEC2HEX
- DEC2OCT
- DECIMAL
- DEGREES
- DELTA
- DEVSQ
- DGET
- DISC
- DMAX
- DMIN
- DOLLAR
- DOLLARDE
- DOLLARFR
- DPRODUCT
- DROP
- DSTDEV
- DSTDEVP
- DSUM
- DURATION
- DVAR
- DVARP
- EDATE
- EFFECT
- ENCODEURL
- EOMONTH
- ERF
- ERF.PRECISE
- ERFC
- ERFC.PRECISE
- ERROR.TYPE
- ERRORTYPE
- EURO
- EUROCONVERT
- EVALUATE
- EVEN
- EXACT
- EXP
- EXPAND
- EXPON.DIST
- EXPONDIST
- F.DIST
- F.DIST.RT
- F.INV
- F.INV.RT
- F.TEST
- FACT
- FACTDOUBLE
- FALSE
- FDIST
- FIELDVALUE
- FILTER
- FILTERXML
- FIND
- FINDB
- FINV
- FISHER
- FISHERINV
- FIXED
- FLOOR
- FLOOR.MATH
- FLOOR.PRECISE
- FORECAST
- FORECAST.LINEAR
- FORECAST.ETS
- FORECAST.ETS.CONFINT
- FORECAST.ETS.SEASONALITY
- FORECAST.ETS.STAT
- FORMULATEXT
- FREQUENCY
- FTEST
- FV
- FVSCHEDULE
- GAMMA
- GAMMA.DIST
- GAMMA.INV
- GAMMADIST
- GAMMAINV
- GAMMALN
- GAMMALN.PRECISE
- GAUGEKPISPARKLINE
- GAUSS
- GCD
- GEOMEAN
- GESTEP
- GROWTH
- Functions H to L
- Functions M to Q
- Functions R to S
- Functions T to Z
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.
Syntax
=DROP(array,rows,[columns])
Arguments
The function has the following arguments:
Argument | Description |
|---|---|
array | Refers to the array from which to drop rows or columns. |
rows | 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.
Data Types
The function returns an array.
Examples
Version Available
This function is available in product version 16.0 or later.
!type=note
Note: The DROP function is only available in Beta Insiders builds of Excel for Office 365 currently. Hence, without the Beta Insiders build you cannot import/export the XLSX using this function from/to Excel.