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 yet. Stay tuned!