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
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
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.
Write to us: support@zohoforms.com