# RANK.EQ formula generator

> Describe what you need and get a RANK.EQ formula for Excel and Google Sheets, run on real data before you copy it. Plus 3 tested RANK.EQ examples.

Source: https://spreadsheetpractice.com/tools/formula-generator/rank-eq · Updated October 29, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

RANK.EQ tells you where a number places within a list: 1 for the largest by default, or 1 for the smallest if you set the order to 1.

Describe the task at [RANK.EQ formula generator](https://spreadsheetpractice.com/tools/formula-generator/rank-eq) and get a RANK.EQ formula for Excel and Google Sheets, tested on real data.

## Tested RANK.EQ examples

### Rank numbers

`=RANK.EQ(B2,$B$2:$B$7)`

Excel. Result on the sample sheet: 6 rows (C2:C7). [See it and try it](https://spreadsheetpractice.com/formulas/rank-values)

### Rank with a tiebreaker

`=RANK.EQ(B2,$B$2:$B$7)+COUNTIFS($B$2:$B$7,B2,$C$2:$C$7,">"&C2)`

Excel. Result on the sample sheet: 6 rows (D2:D7). [See it and try it](https://spreadsheetpractice.com/formulas/rank-with-a-tiebreaker)

### Make a ranked leaderboard with a formula

`=SORT(HSTACK(RANK.EQ(B2:B9,B2:B9),A2:B9),1)`

Excel. Result on the sample sheet: 8 rows (D2:F9). [See it and try it](https://spreadsheetpractice.com/formulas/make-a-ranked-leaderboard)

## Questions

### What does the RANK.EQ formula generator do?

You describe the task in plain English, and it writes the formula, using RANK.EQ where that's the right tool, for your table or a sample one. The formula is run in our engine in Excel and Google Sheets mode before you see it, so you get its result, not just a guess.

### What does RANK.EQ do?

RANK.EQ tells you where a number places within a list: 1 for the largest by default, or 1 for the smallest if you set the order to 1.

### Can I learn to write RANK.EQ formulas myself?

Yes. Each example below opens a page where you try the formula in a live grid and it's checked as you go, and the RANK.EQ function page has a practice exercise.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
