TAKE function - Zoho Sheet - Help Guide

TAKE

Returns the specified number of continuous rows or columns from the start or end of the given array.
 
Syntax
 
TAKE(array; rows; [columns])
array: The range of cells containing the input values. E.g. A2:C9
rows: The number of rows to return. Positive values take rows from the top of the array, while negative values take rows from the bottom. E.g. 3
columns: The number of columns to return. Positive values take columns from the left of the array, while negative values take columns from the right. E.g. -2
 
Examples
 
Formula
=TAKE(A2:C9;3)
=TAKE(A2:C9;1;-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