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

#### 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

#### AliGW

##### Active Member
Yes:

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

#### Rodger

##### Member
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

##### Well-Known Member
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
)`````` #### p45cal

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