Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
RANK.AVG
RANK.AVG assigns tied values the average of the ranks they would have occupied. For example, two values tied for 2nd and 3rd each receive rank 2.5. This approach is preferred in statistical work to avoid inflating or deflating rank sums.
Topic:RANK & statistical aggregatesExcel
=RANK.AVG(B2,B2:B5,0)Google Sheets
=RANK.AVG(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, range, and order: =RANK.AVG(B2,B2:B5,0).
- 2Lock the range before copying down: =RANK.AVG(B2,$B$2:$B$5,0).
- 3Tied values receive the average of their shared ranks rather than the top rank.
Need a version for your data?
Try: “Rank test scores using averaged ranks so that ties don't distort statistical analysis”
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-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.