> For the complete documentation index, see [llms.txt](https://docs.nedyx.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/row.md).

# ROW

Returns a row of a range.

#### Syntax <a href="#syntax.45" id="syntax.45"></a>

**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 <a href="#remarks.35" id="remarks.35"></a>

* 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

<figure><img src="https://3148043601-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL43fiRbeRtPnTjMpbGNO%2Fuploads%2Fgit-blob-a8f75473a1293885596b79e2fb404126f071ebee%2Fgrafik%20(479).png?alt=media" alt=""><figcaption></figcaption></figure>