Ranking With RANK and PERCENTILE

Often you do not just want the value, you want its position within the group. Is this salesperson 1st or 12th? Is this score in the top 10%?

Two function families answer this: RANK tells you the ordinal position, and PERCENTILE tells you the value at a given cutoff. Together they turn raw numbers into rankings and benchmarks.

RANK.EQ gives a value's position within a range. You pass the value, the range, and an order flag.

• Order 0 (or omitted) ranks largest-first (descending).
• Order 1 ranks smallest-first (ascending).

Here the highest sales figure gets rank 1.