Nth

Description of formula:
Returns an element, which occurs in the array at a given position. You can specify an array of values or cells range.
Syntax:
nth(array, position)
Parameters:
array
(type: array of values of any type) Array from which you want to get element
position
(type: Number) Position from which to return a value. Must be greater than or equal to 1 and not exceed the length of the array.
Returned type:
any
Examples:
=nth(array(1, 2, 5), 2)
=nth(A1:A12, 6)
=nth(section1.A,1)
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk