# RowNumber

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

## Usage

RowNumber(column, direction)

**column** (optional) 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.*

## Example

RowNumber([Population by State], "asc")

- 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])