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

[Rodger]

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

 

[AliGW]

Yes:

=RANK(A1,$A$1:$A$7,0)&IF(COUNTIF($A$1:$A$7,A1)>1,"-T","")

 

[Rodger]

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

 

[Peter Bartholomew]

This is 365 only, and already getting heavy

= 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

= 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
   )

 

[p45cal]

If you insist on adding "-T" for ties, it can only get worse