Hi - I have a formula which lists users in descending order based on their performance stats. However, if someone has the same performance figure as another user, then it lists the same user again.
Can this formula be tweaked to list the other users who have the same figure as someone else in the range?![]()
=OFFSET(INDEX(Rank_Total,MATCH(SMALL(COUNTIF(Rank_Total,">"&Rank_Total),ROW(1:1)),COUNTIF(Rank_Total,">"&Rank_Total),0)),0,-9)
Bookmarks