Essentially, this “replaces” the rank value that was skipped originally.
The same process repeats as the formula is copied down the column.
If another duplicate is encountered, the rank value is increased by 2, and so on.
RANK can rank values from largest to smallest (i.e.
top sales) as well as smallest to largest (i.e.
