Forum Discussion

Copper Contributor

Jul 25, 2025

Please Help Excel Rank Dilemma

Name Score back 6 back 3 back 1 Rank Rank should be John 26 13 5 1 6 6 Howard 26 11 6 0 5 7 Kevin 26 14 5 3 2 5 Declan 26 14 8 4 2 2 ...

Silver Contributor

Jul 28, 2025

I may need to see more sample data and outcomes but this matches your desired return:

=LET(
    rank, SORTBY(name, Score, -1, back_6, -1, back_3, -1, back_1, -1),
    desired, XMATCH(name, rank),
    desired
)