Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to rank values with ties broken in Excel and Google Sheets
Topic:RANK & statistical aggregatesExcel & Google Sheets
=RANK.EQ(B2,$B$2:$B$5,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
Step by step
- 1Enter your data into a column.
- 2In an adjacent cell, use the RANK.EQ function to rank the first value in your data column.
- 3Drag the fill handle down to apply the formula to other cells in the column.
Tips
- Ensure your data range is correctly specified to avoid errors.
- The third argument in RANK.EQ (0 for descending, 1 for ascending) can be omitted if descending order is desired.
- Check for any non-numeric data that might cause errors in ranking.
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
What happens if there are duplicate values in my data?
The RANK.EQ function will assign the same rank to duplicate values, but it will skip subsequent ranks.
Can I rank in ascending order instead of descending?
Yes, set the third argument of RANK.EQ to 1 for ascending order.
Is there a difference between Excel and Google Sheets for this function?
No, the RANK.EQ function works the same way in both Excel and Google Sheets.
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.
ReferenceRANK.AVG
Returns the rank of a number, averaging ranks for ties. Useful in statistical analysis where tied ranks should not cluster.
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.
ReferencePERCENTILE
Returns the k-th percentile value from a dataset. Useful for performance benchmarking and threshold analysis.
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.