Formulas > =PERCENTRANK()
How to Use PERCENTRANK() in Google Sheets
Description
How To Actually Use PERCENTRANK() in Sheets
PERCENTRANK(data, value, [significant_digits])
Try PERCENTRANK yourself
Use the PERCENTRANK formula to find the percentile rank of the value in cell B1 within the dataset A1:A10. The result should be displayed in cell C1.
Hints (2)
-
Make sure to reference the correct range for your dataset.
-
Remember to use the value from cell B1 in your formula.
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 PERCENTRANK() formula:
Generate a PERCENTRANK() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses PERCENTRANK(). 2 free AI generations, no signup. Members get unlimited use.
Generate a PERCENTRANK() formula