> 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.52-preview/clearlines-functions/range-functions.md).

# Range functions

- [AGGREGATE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/aggregate.md): Aggregates rows of a range based on duplicate elements.
- [CELL](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/cell.md): Returns a cell of a range.
- [CELLREF](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/cellref.md): Inserts an area at a desired position in a table widget.
- [CLEAR](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/clear.md): Converts an error to an empty value.
- [COLUMN](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/column.md): Returns a column of a range.
- [COLUMNS](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/columns.md): Returns specific columns of a range.
- [COMBINE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/combine.md): Returns the combination of two or more ranges.
- [CONVERT](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/convert.md): Converts values to a specific value type.
- [COUNT](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/count.md): Returns the number of numeric cells in a range.
- [CSVTORANGE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/csvtorange.md): Returns a range which has been extracted from a CSV (comma separated version) text.
- [CUMULATE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/cumulate.md): Cumulates a range of values, i.e. every number of the range is added to the sum of all previous numbers.
- [DIFF](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/diff.md): Removes rows from a range.
- [EMPTY](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/empty.md): Returns empty cells.
- [FILTER](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/filter.md): Returns a range which is filtered based on a condition.
- [GETTYPE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/gettype.md): Returns the type of a value.
- [INSERTRANGE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/insertrange.md): Returns a range where another range has been inserted.
- [INTERSECTION](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/intersection.md): Returns elements of a range which are included in another range as well.
- [LOOKUP](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/lookup.md): Maps rows from a range according to a column of key values.
- [PIVOT](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/pivot.md): Converts a row-based range of values to a column-based range of values.
- [RANGE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/range.md): Returns a part of a range.
- [RANGETOCSV](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/rangetocsv.md): Returns a CSV (comma separated version) representation of a range.
- [RANGETOHIERARCHY](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/rangetohierarchy.md): Converts a range to a hierarchy.
- [RANGETOROW](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/rangetorow.md): Converts a range of cells to a row range.
- [RANGETOJSON](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/rangetojson.md): Converts a range of cells to a json text.
- [JSONTORANGE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/jsontorange.md): Converts a json text to a range of cells.
- [ROW](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/row.md): Returns a row of a range.
- [ROWS](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/rows.md): Returns specific rows of a range.
- [ROWTORANGE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/rowtorange.md): Converts the cells of a row into a range.
- [SEQUENCE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/sequence.md): Returns a range of sequential numbers.
- [SORT](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/sort.md): Returns a range which is sorted based on values in one or more columns.
- [TRANSPOSE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/transpose.md): Returns a range with exchanged rows and columns.
- [UNIQUE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/unique.md): Removes duplicate rows or columns from a range.
- [UNPIVOT](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/unpivot.md): Converts a column-based range of values to a row-based range of values.
- [VISIBLEHIERARCHY](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/visiblehierarchy.md): Returns for hierarchy widgets the currently visible rows.