• The forum (and all other resources in Chandoo.org) will be under maintenance and will be unavailable for a maximum of two hours on the first week of October 2023. The exact date, time and duration of the maintenance are subject to change. We regret the inconvience it may cause.

  • Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Ranking based on score ( first second, tied for third)

R

Rodger

Member
I am trying something new, and need help.
I have Column C with a YTD total. Is it possible to have Column A rank the players, IE: 1, 2, 3-T, 3-T, (if they have the same total), 4, etc
 
Thank you so much, this works, but ...

This ranks them 1,1,1 4.4,6 etc.
Is it possible that they are ranked 1,1,1,2,2,3, etc?

I hope that makes sense ...

Rodger
 
This is 365 only, and already getting heavy
Code: 
= LET(
     distinct, UNIQUE(total),
     group,    MAP(distinct, LAMBDA(d, COUNT(IF(distinct<=d,1)))),
     XLOOKUP(total, distinct, group)
  )
If you insist on adding "-T" for ties, it can only get worse
Code: 
= LET(
     distinct, UNIQUE(total),
     group,    MAP(distinct, LAMBDA(d, COUNT(IF(distinct<=d,1)))),
     rank,     XLOOKUP(total, distinct, group),
     suffix,   IF(COUNTIFS(total,total)>1, "-T", ""),
     rank & suffix
   )
81692
 
You must log in or register to reply here.
Back
Top