Lookup & Reference
Excel 365
◉ 8 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 — Coming soon
▦ 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
حذف ۲ سطر اول از آرایه A2:C4
=DROP(A2:C4,2)
حذف ۲ ستون اول از آرایه A2:C4
=DROP(A2:C4,,2)
حذف ۲ سطر آخر از آرایه A2:C4 (مقدار منفی)
=DROP(A2:C4,-2)
حذف ۲ سطر و ۲ ستون از آرایه A2:C4
=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!