Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
RANK.EQ
RANK.EQ returns the position of a value in a sorted list, giving tied values the same (top) rank and skipping subsequent ranks. It replaces the legacy RANK function and is the standard choice when ties should share the highest rank.
Topic:RANK & statistical aggregatesExcel
=RANK.EQ(B2,B2:B5,0)Google Sheets
=RANK.EQ(B2,B2:B5,0)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
How it works
- 1Enter the value to rank, the full list range, and 0 for descending or 1 for ascending: =RANK.EQ(B2,B2:B5,0).
- 2Lock the reference range with $ signs when copying down: =RANK.EQ(B2,$B$2:$B$5,0).
- 3Ties receive the same rank; the next rank(s) are skipped accordingly.
Need a version for your data?
Try: “Rank each salesperson's revenue from highest to lowest, with ties getting the same rank”
More on RANK & statistical aggregates
See all →Reference
RANK.AVG
Returns the rank of a number, averaging ranks for ties. Useful in statistical analysis where tied ranks should not cluster.
How-toHow to rank values
Rank a number against a list with RANK — highest first or lowest first. Works the same in Excel and Google Sheets.
ReferencePERCENTILE
Returns the k-th percentile value from a dataset. Useful for performance benchmarking and threshold analysis.
How-toHow 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.
How-toHow 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.
How-toHow 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.