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.
81% OFF online library of tutorials for mastering Google Sheets
RANK.AVG()
Description
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.