RANK Function Generator
RANK returns the position of a value within a range when sorted. Use RANK.EQ for standard competition ranking; RANK.AVG averages tied ranks.
Syntax
=RANK.EQ(number, ref, [order])Try it — generate a RANK formula
Examples
Highest sales = rank 1
=RANK.EQ(A2, A$2:A$100, 0)order=0 (default): descending. Highest value ranks first.
Lowest time = rank 1
=RANK.EQ(A2, A$2:A$100, 1)order=1: ascending. Best for times or golf scores.
Top 10 flag
=RANK.EQ(A2, A$2:A$100)<=10Returns TRUE for top 10 rows.
Tips
- ✓Use absolute references ($) for the range so it doesn't shift when dragged.
- ✓Ties get the same rank; the next rank skips by the tie count.
- ✓RANK.AVG averages tied positions (1.5 for two tied at rank 1).
Related Formulas
PERCENTILE
PERCENTILE returns the Kth percentile of a data range. Common in performance (p9...
MEDIAN
MEDIAN returns the middle value when a range is sorted. More robust than AVERAGE...
STDEV
STDEV calculates the standard deviation of a data set — how spread out values ar...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free