This works perfectly as long as numeric values are unique.
This means the expression will return zero for each numeric value until a duplicate is encountered.
This effectively breaks ties, and allows the formula to generate a sequential list of numbers with no gaps.
Once the formula is in place, data can be sorted by thehelper column.
It can also be retrieved with INDEX using the values in the helper column.
RANK can rank values from largest to smallest (i.e.
top sales) as well as smallest to largest (i.e.
