Find what percentile a specific value sits at within a dataset.
Copy this formula
=PERCENTRANK.INC(A2:A100, B2)PERCENTRANK.INC returns a value's relative standing as a percentile between 0 and 1 — 0.9 means it's higher than 90% of the data. It's the inverse of PERCENTILE.
=PERCENTRANK.INC(Scores, 85)→0.7885 beats 78% of the scores.
RANK gives an ordinal position (3rd); PERCENTRANK gives a relative percentage of the data below it.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.