> 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/version-1.66/nedyx/clearlines-functions/range-functions/rows.md).

# ROWS

#### Syntax

**ROWS**(*range*; *rowIndex1*; row*Index2*; …; row*IndexN*)

* *range* - the range from which the rows should be extracted *- **Value type**: range*
* *rowIndex1-N* - the indicees of the rows which should be included in the return range - ***Value type**: number*

#### Remarks

* The order of the rows in the return range is the same as the order of the *rowIndex* parameters.
* If a row does not exist in *range*, a row with empty cells is included in the range.
* It is possible to use the same index multiple times, then the same row is included multiple times in the result range.

#### Examples

The left table is filled with the rows 1 and 3 of table1:

<div align="left"><figure><img src="/files/aQxYRvTQLBI5clYKLVGm" alt=""><figcaption></figcaption></figure></div>

The left table is filled with several rows of table2 in a custom order. Including an empty row, by using 0 as index:

<div align="left"><figure><img src="/files/TNn4e6thdcZpkYePKbHs" alt=""><figcaption></figcaption></figure></div>