DROP function - Zoho Sheet - Help Guide

DROP

Returns the given array after removing a specified number of rows and columns.
 
Syntax
 
DROP(array; rows; [columns])
array: The range of cells containing the input values. E.g. A2:C9
rows: The number of rows to exclude. Positive values exclude rows from the top, while negative values exclude rows from the bottom. E.g. 4
columns: The number of columns to exclude. Positive values exclude columns from the left, while negative values exclude columns from the right. E.g. -2
 
Examples
 
Formula
=DROP(A2:C9;6)
=DROP(A2:C9;4;-2)

Get a hands-on experience of the function in the embedded range below. 



Possible Errors
 
Errors
Meaning
#NAME!
  • The function name is incorrect or invalid.
  • The given defined name (if any) is invalid.
  • There is a typo in the defined name used in the function.
  • Double quotes are missing for text values in the function.
  • Colon missing in a cell range reference.
#VALUE!
  • The given argument's data type is incorrect or invalid.
  • The array is empty i.e. rows or columns is 0.
#REF!
  • The given cell reference is incorrect or invalid. This error may occur when a cell/range has been deleted, moved, or pasted over.
#NUM!
  • The given array is too large.
 
Similar Functions
  1. TAKE