This function ranks all values from lowest to highest (ascending) or highest to lowest (descending). The user has the choice of Rank (ascending) or Rank (descending).
Take the values in the column and sort according to select.
Assign a number to each row, starting at 1.