Function Index

RowNumber

Number the rows in the table using the input column. Begins with 1.

Usage

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

column (required) The column used to order the table. The input column can be numbers, dates or text.

direction (optional) The direction to sort the input column. Default is to sort ascending.

NOTE: Each rows is numbered according to the input column’s ordering, without taking into account duplicate values.  For example: if the input has “Anne”, “Jane”, “Jane” and “Pari”, they would be ranked 1, 2, 3 and 4.

Examples

RowNumber([Population by State])

  • This assigns the smallest population 1, the second smallest 2 and so on with each population being assigned the next number in the sequence even when the values are identical.
RowNumber([COUNTY - Count])