Formulas > =RANK.AVG()
How to Use RANK.AVG() in Google Sheets
Description
How To Actually Use RANK.AVG() in Sheets
RANK.AVG(value, data, [is_ascending])
Try RANK.AVG yourself
Use the RANK.AVG formula to find the rank of the value in cell A1 within the dataset in A2:A10. The formula should return the average rank if there are duplicates.
Hints (2)
-
Remember to reference the correct range for the dataset.
-
Make sure to include the cell for the value you want to rank.
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
Learn more about the RANK.AVG() formula:
Generate a RANK.AVG() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses RANK.AVG(). 2 free AI generations, no signup. Members get unlimited use.
Generate a RANK.AVG() formula