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.