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)

 

Available from version 2.3
Selecting an item from attachment type cells
The nth formula can also be used to select a specific attachment from a cell or section of an attachment type. This allows you to retrieve, for example, the first, second or seventh attachment.

Syntax:
nth(attachment array, position)

Parameters:

attachment array

(type: address of attachment type cell or attachment type section) 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:

attachment array

Examples:
=nth(section21.b1,3)
=nth(section20,3)
=nth(section30.b2:b5,2)