ROW

Returns a row of a range.

Syntax

ROW(range; rowIndex)

• range - the range from which a row should be returned - Value type: range

• rowIndex - the index of the row to return - Value type: integer (optional, default value: 1)

Remarks

• If rowIndex is greater than the number of rows in range or smaller than 1, an empty row with the same amount of columns as range is returned.

• rowIndex can contain the text “last”. In this case, the last row of range is returned.

Example