FormulaCraft

How to rank values in Excel and Google Sheets

Topic:RANK & statistical aggregates
Excel & Google Sheets
=RANK(B2, $B$2:$B$100)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

Step by step

  1. 1In a new column, enter =RANK(B2, $B$2:$B$100).
  2. 2The $ signs lock the list so every row ranks against the same range.
  3. 3Copy it down. By default the largest value ranks 1.

Tips

Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.

Frequently asked

How do I rank from lowest to highest?

Set the order argument to 1, e.g. =RANK(B2, $B$2:$B$100, 1). Leave it blank or 0 for highest-first.

More on RANK & statistical aggregates

See all →
Reference

RANK.EQ

Returns the rank of a number in a list, assigning the same rank to ties (same as RANK). Essential for leaderboards.

How-to

How to calculate standard deviation

Measure how spread out your numbers are with STDEV for a sample or STDEVP for a whole population. Works in Excel and Google Sheets.

Reference

RANK.AVG

Returns the rank of a number, averaging ranks for ties. Useful in statistical analysis where tied ranks should not cluster.

How-to

How to calculate a weighted average

Combine values and their weights with SUMPRODUCT divided by the total weight. Works the same in Excel and Google Sheets.

Reference

PERCENTILE

Returns the k-th percentile value from a dataset. Useful for performance benchmarking and threshold analysis.

How-to

How to calculate standard deviation

Use STDEV.S for a sample or STDEV.P for a full population to measure the spread of values around the mean.

Formulas used

MAX / MINCOUNTIF

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: