RankPercentile
Last updated
Was this helpful?
Last updated
Was this helpful?
Rank the rows in the table by percentile using the input column.
RankPercentile(column, [direction])
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.
📘The is a number between 0 and 1. The last row is always 1 and the first is 0, unless there is only 1 row or there is a tie for the top value. To display the result as percentages as opposed to numbers, change the column formatting from Automatic to Percent.
RankPercentile([Population by State])
This assigns the state with the smallest population rank 0, the largest population is assigned rank 1.
RankPercentile([Population 2010])
RankPercentile([COUNTY - Count])
