Functions
RANK.AVG
Rank with average for ties
Try it
When to use it
When should I use RANK.AVG instead of RANK.EQ?
Use RANK.AVG when your dataset contains ties and you want tied values to share the average of the positions they would have occupied, which avoids gaps in the ranking sequence and is required in many statistical tests.
Used in
Syntax
RANK.AVG(number,ref,[order])Examples
=RANK.AVG(5,{1,2,3,4,5,6,7,8,9,10}) // => 6
=RANK.AVG(5,{1,2,3,4,5,6,7,8,9,10},TRUE) // => 5
=RANK.AVG(5,{1,2,3,4,5,6,7,8,9,10},FALSE) // => 6