# Range functions

- [AGGREGATE](/nedyx/clearlines-functions/range-functions/aggregate.md): Aggregates rows of a range based on duplicate elements.
- [CELL](/nedyx/clearlines-functions/range-functions/cell.md): Returns a cell of a range.
- [CLEAR](/nedyx/clearlines-functions/range-functions/clear.md): Converts an error to an empty value.
- [COLUMN](/nedyx/clearlines-functions/range-functions/column.md): Returns a column of a range.
- [COLUMNS](/nedyx/clearlines-functions/range-functions/columns.md): Returns specific columns of a range.
- [COMBINE](/nedyx/clearlines-functions/range-functions/combine.md): Returns the combination of two or more ranges.
- [CONVERT](/nedyx/clearlines-functions/range-functions/convert.md): Converts values to a specific value type.
- [COUNT](/nedyx/clearlines-functions/range-functions/count.md): Returns the number of numeric cells in a range.
- [CROSSJOIN](/nedyx/clearlines-functions/range-functions/crossjoin.md): Creates a cartesian product by combining rows from multiple ranges.
- [CSVTORANGE](/nedyx/clearlines-functions/range-functions/csvtorange.md): Returns a range which has been extracted from a CSV (comma separated version) text.
- [CUMULATE](/nedyx/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](/nedyx/clearlines-functions/range-functions/diff.md): Removes rows from a range.
- [EMPTY](/nedyx/clearlines-functions/range-functions/empty.md): Returns empty cells.
- [FILTER](/nedyx/clearlines-functions/range-functions/filter.md): Returns a range which is filtered based on a condition.
- [FLIPCELLS](/nedyx/clearlines-functions/range-functions/flipcells.md): Flips a range of values in a specified direction.
- [GETTYPE](/nedyx/clearlines-functions/range-functions/gettype.md): Returns the type of a value.
- [INSERTRANGE](/nedyx/clearlines-functions/range-functions/insertrange.md): Returns a range where another range has been inserted.
- [INTERSECTION](/nedyx/clearlines-functions/range-functions/intersection.md): Returns elements of a range which are included in another range as well.
- [LEVEL](/nedyx/clearlines-functions/range-functions/level.md): Returns the hierarchy levels of visible rows in a hierarchy widget.
- [LOOKUP](/nedyx/clearlines-functions/range-functions/lookup.md): Maps rows from a range according to a column of key values.
- [MOVECELLS](/nedyx/clearlines-functions/range-functions/movecells.md): Moves non-empty cells within a range in a specified direction, optionally removing empty cells.
- [PIVOT](/nedyx/clearlines-functions/range-functions/pivot.md): Converts a row-based range of values to a column-based range of values.
- [RANGE](/nedyx/clearlines-functions/range-functions/range.md): Returns a part of a range.
- [RANGETOCSV](/nedyx/clearlines-functions/range-functions/rangetocsv.md): Returns a CSV (comma separated version) representation of a range.
- [RANGETOHIERARCHY](/nedyx/clearlines-functions/range-functions/rangetohierarchy.md): Converts a range to a hierarchy.
- [RANGETOROW](/nedyx/clearlines-functions/range-functions/rangetorow.md): Converts a range of cells to a row range.
- [RANGETOJSON](/nedyx/clearlines-functions/range-functions/rangetojson.md): Converts a range of cells to a json text.
- [JSONTORANGE](/nedyx/clearlines-functions/range-functions/jsontorange.md): Converts a json text to a range of cells.
- [ROW](/nedyx/clearlines-functions/range-functions/row.md): Returns a row of a range.
- [ROWS](/nedyx/clearlines-functions/range-functions/rows.md): Returns specific rows of a range.
- [ROWTORANGE](/nedyx/clearlines-functions/range-functions/rowtorange.md): Converts the cells of a row into a range.
- [SEQUENCE](/nedyx/clearlines-functions/range-functions/sequence.md): Returns a range of sequential numbers.
- [SORT](/nedyx/clearlines-functions/range-functions/sort.md): Returns a range which is sorted based on values in one or more columns.
- [TRANSPOSE](/nedyx/clearlines-functions/range-functions/transpose.md): Returns a range with exchanged rows and columns.
- [TRIMCELLS](/nedyx/clearlines-functions/range-functions/trimcells.md): Removes empty rows or columns from a range.
- [UNIQUE](/nedyx/clearlines-functions/range-functions/unique.md): Removes duplicate rows or columns from a range.
- [UNPIVOT](/nedyx/clearlines-functions/range-functions/unpivot.md): Converts a column-based range of values to a row-based range of values.
- [VISIBLEHIERARCHY](/nedyx/clearlines-functions/range-functions/visiblehierarchy.md): Returns for hierarchy widgets the currently visible rows.