Lookup & Reference
Excel 365
◉ 29 views
Dynamic Array
=DROP()
DROP function
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for Mac
=DROP(array, rows,[columns])
Hover argument names in the table for details.
Output typeArray
Popularity40 / 100
VolatileNo
Dynamic ArrayYes
Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =DROP() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
array |
Array | Optional | The array from which to drop rows or columns. |
rows |
Number | Optional | The number of rows to drop. A negative value drops from the end of the array. |
columns |
Number | Optional | The number of columns to exclude. A negative value drops from the end of the array. |
▣ Examples
▦ Data
| Cell | Value |
|---|---|
A2 |
1 |
B2 |
2 |
C2 |
3 |
A3 |
4 |
B3 |
5 |
C3 |
6 |
A4 |
7 |
B4 |
8 |
C4 |
9 |
A5 |
1 |
B5 |
2 |
C5 |
3 |
A6 |
4 |
B6 |
5 |
C6 |
6 |
A7 |
7 |
B7 |
8 |
C7 |
9 |
A8 |
1 |
B8 |
2 |
C8 |
3 |
A9 |
4 |
B9 |
5 |
C9 |
6 |
A10 |
7 |
B10 |
8 |
C10 |
9 |
A11 |
1 |
B11 |
2 |
C11 |
3 |
A12 |
4 |
B12 |
5 |
C12 |
6 |
A13 |
7 |
B13 |
8 |
C13 |
9 |
A14 |
1 |
B14 |
2 |
C14 |
3 |
A15 |
4 |
B15 |
5 |
C15 |
6 |
A16 |
7 |
B16 |
8 |
C16 |
9 |
A17 |
1 |
B17 |
2 |
C17 |
3 |
A18 |
4 |
B18 |
5 |
C18 |
6 |
A19 |
7 |
B19 |
8 |
C19 |
9 |
A20 |
1 |
B20 |
2 |
C20 |
3 |
A21 |
4 |
B21 |
5 |
C21 |
6 |
A22 |
7 |
B22 |
8 |
C22 |
9 |
A23 |
1 |
B23 |
2 |
C23 |
3 |
A24 |
4 |
B24 |
5 |
C24 |
6 |
A25 |
7 |
B25 |
8 |
C25 |
9 |
Example 1
=DROP(A2:C4,2)
Example 2
=DROP(A2:C4,,2)
Example 3
=DROP(A2:C4,-2)
Example 4
=DROP(A2:C4,2,2)
⚠ Common Errors
#CALC!
Excel returns a #CALC! error to indicate an empty array when rows or columns is 0.
Fix: Reduce the number of rows or columns to remove
#NUM!
Excel returns a #NUM when array is too large.
Fix: محدوده آرایه را کوچکتر کنید یا تعداد سطرها و ستونهای درخواستی را کاهش دهید.
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!