If the data contains all text values, or all numeric values, the rank will be correct.
This effectively cancels out the COUNT result when we are working with a number in the current row.
For more information about how this formula works,see the example here.
Dealing with blanks
Empty cells will generate a rank of zero.
RANK can rank values from largest to smallest (i.e.
top sales) as well as smallest to largest (i.e.
Numbers include negative numbers, percentages, dates, times, fractions, and formulas that return numbers.
