Functions
RANK.EQ
Rank with equal (lowest) for ties
Try it
When to use it
When should I use RANK.EQ?
Use RANK.EQ to rank a number within a list where ties are assigned the same lowest rank, making it suitable for leaderboards or grading where you do not want average ranks.
Used in
Syntax
RANK.EQ(number,ref,[order])Examples
=RANK.EQ(5,{1,2,3,4,5,6,7,8,9,10}) // => 6
=RANK.EQ(5,{1,2,3,4,5,6,7,8,9,10},TRUE) // => 5
=RANK.EQ(5,{1,2,3,4,5,6,7,8,9,10},FALSE) // => 6