Returns a row of a range.


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)


  • 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.