How to Use RANK.EQ() in Google Sheets

Description

Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the top rank of the entries will be returned.

How To Actually Use RANK.EQ() in Sheets

RANK.EQ(value, data, [is_ascending])

Try RANK.EQ yourself

Use the RANK.EQ formula to find the rank of the value in cell A1 within the range A1:A10. The correct answer should return the rank of the score in A1 compared to the other scores in the range.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Transcript-matched member videos for RANK.EQ(). Click through to watch.

Browse more tutorials

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Unlock these tutorials

Learn more about the RANK.EQ() formula:

Generate a RANK.EQ() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses RANK.EQ(). 2 free AI generations, no signup. Members get unlimited use.

Generate a RANK.EQ() formula

How to Use RANK.EQ() in Google Sheets

Try RANK.EQ yourself

More related tutorials

Calculate ROAS in Google Sheets