81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



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 average rank of the entries will be returned.

How To Use in Sheets

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

External Links

Rank.avg function example in excel

This video shows you how to get average rank in a list of same values using rank.avg formula in MS Excel 2019 Office 365.

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.