Returns the percentage rank (percentile) of a specified value in a dataset.

How To Use in Sheets

PERCENTRANK(data, value, [significant_digits])

External Links

Rank, Percentrank, & Percentile Functions

This video is part of the series on Statistical Functions. More videos and tutorials about spreadsheet learning can be found at Please select the HD quality setting when viewing this video in full-screen mode.

0Better Sheets Tutorials

No videos yet. Stay tuned!