> 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/column.md).

# COLUMN

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

**COLUMN**(*range*; *columnIndex*)

* *range* - a range of values - ***Value type**: range*
* *columnIndex* - the index of the column to return - ***Value type**: number (optional, default value: 1)*

#### Remarks <a href="#remarks.6" id="remarks.6"></a>

* If *columnIndex* is greater than the number of columns in *range* or smaller than 1, an empty column with the same amount of rows as *range* is returned.
* *columnIndex* can contain the text “last”. In this case, the last column of *range* is returned.
* The function COLUMN can be used to ensure that a parameter or operand is always handled as a column during an operation.

#### Example

The left widget is filled with the second column of table2, by calling the COLUMN function with 2 as second parameter.

<figure><img src="/files/Lvg7SrURMykkprgGjW1r" alt=""><figcaption></figcaption></figure>