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! |
|
#VALUE! |
|
#REF! |
|
#NUM! |
|
Similar Functions
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Zoho FSM Video Tutorials
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho CPaaS?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Do I need to save my spreadsheet after editing in Zoho Sheet?
No. Every modification you and your collaborators make to the Zoho Sheet spreadsheet will be automatically saved. The last modified time of the spreadsheet is shown at the right top corner. You can use features like Audit Trail and Version History ...Insert an image into the spreadsheet (Android)
To insert an image: Go to the icon Under the Insert menu, choose Image. Choose Image In Cell to insert the image within a cell, and Image Over Cells to insert it over the grid. You can choose an image from your device gallery or WorkDrive library, or ...Insert an image in to spreadsheet (iPhone)
To insert an image: Go to icon Under the Insert menu, choose Image. Choose Image In Cell to insert the image within a cell, and Image Over Cells to insert it over the grid. You can choose an image from your device library or take one using the ...Editing a cell in Zoho Sheet (Web)
Click on the cell that you want to edit. From there, you can take the cell to it's edit state by hitting enter, or double clicking the cell. After the edits are done, you can press enter, and your will be taken to the next line,Monitor and manage specific features from the admin panel
Zoho WorkDrive admin users will have access to the admin panel, from which they can monitor and manage specific features and credit points for their org users. The admin can switch between organizations/teams in the dropdown. Only if the user is an ...
New to Zoho LandingPage?
Zoho LandingPage Resources