Function Index

RankDense

Rank the rows in the table using the input column. Begins with 1. Identical values are assigned identical rank, but no gaps are inserted into the number sequence. Defaults to sort ascending.

Usage

RankDense(<column>,<direction ”asc” | “desc”>)

column (required) The column used to order the table.

direction (optional) The direction to sort the input column. Enter is “asc” to sort ascending and “desc” to sort descending. Default sort is ascending.

NOTE: Rows which sort identically are ranked identically, and no gaps are inserted into the number sequence. For example: if the input has “Anne”, “Jane”, “Jane” and “Pari”, they would be ranked 1, 2, 2 and 3.

Examples

RankDense([Population by State])
  • This will assign the state with the smallest population rank 1, the second smallest population will be assigned rank 2 and so on.
RankDense([Population by State], “desc”)
  • This will rank the state with largest population as rank 1, the second smallest populations will be assigned rank 2, and so on.
RankDense([County - Count])