TOP
Returns top part/whole array from the top of given data_range after sorting it in descending order.
Syntax
data_range: The array or range containing the input data. E.g. A2:D8
sort_index: The position of the row/column to sort in the given data_range. E.g. 3
result_index: The position of the row/column, in the given data_range from which you want the result. Defaults to the sort_index value if omitted. E.g. 1
Examples
|
Formula |
Result |
|
=TOP(A2:D8;3;1;3) |
Possible Errors
|
Errors |
Meaning |
|
#N/A! |
|
|
#NAME! |
|
|
#VALUE! |
|
|
#REF! |
|
Similar Functions
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:
Still can't find what you're looking for?
Write to us: support@zohoforms.com
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho SalesIQ Resources
Zoho TeamInbox Resources
Zoho DataPrep Resources
Design. Discuss. Deliver.
Related Articles
Insert a button in a sheet
To insert button: Click Insert > Button. Label the button. Click on the "..." on the right top of the button and choose "Edit Label" to rename the button.Clone/delete a button
To clone/delete a button: Click the Advance Options on the top-right corner of the button or right click on the button. Select Clone or Delete to create a replica of the button or to remove it permanently.Delete an image
To delete an image: 1. Right click on the image and select Delete. Alternatively, you can click on the image and hit Delete. 2. You can also use the Advance Options menu from the top right corner of the image.Get the image in its original size
To get the original size of an image: Right click on the image and select Resize To Original Size. You can also use the Advance Options menu from the top right corner of the image.Duplicate a spreadsheet
To make a copy of a spreadsheet: Go to ... near the respective file name in the file listing screen or at the top-right corner inside the editor. Choose Create a copy.