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