> 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

#### 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="/files/vqxeP5Bl3VJRiL3Y2HpB" alt=""><figcaption></figcaption></figure>