# Range functions

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