# Ranking Duplicate Data - Golf Leaderboard

#### wayne0881

##### Board Regular
Hi All,

I have created a golf leaderboard and i'm trying to have any duplicate values assigned with a T to define Tied

For example:
Player Score Rank
Player 1 -3 1
Player 2 -1 T2
Player 3 -1 T2
Player 4 +1 4

the formula i'm using is =IF(OR(L4=L5,L4=L3),"T"&L4,L4) but only some are displaying the T even though they match the criteria?? but when I click inside the function box to check the code it changes and works??

so I don't know what is going on - any ideas would be grateful

Cell Formulas
RangeFormula
B4B4=Scorecard!B196
C4:C36C4=IF(OR(L4=L5,L4=L3),"T"&L4,L4)
D4:D36D4=IF(SUM(G4:J4)-(COUNTA(G4:J4)*\$B\$2)=0,"E",(SUM(G4:J4)-(COUNTA(G4:J4)*\$B\$2)))
B5B5=Scorecard!B97
B6,B8,B11,B18B6=Scorecard!B190
B7B7=Scorecard!B142
B9B9=Scorecard!B115
B10B10=Scorecard!B204
B12B12=Scorecard!B165
B13,B29B13=Scorecard!B51
B14B14=Scorecard!B109
B15B15=Scorecard!B15
B16B16=Scorecard!B167
B17,B22B17=Scorecard!B91
B19B19=Scorecard!B79
B20,B33B20=Scorecard!B157
B21B21=Scorecard!B74
B23B23=Scorecard!B39
B24B24=Scorecard!B64
B25B25=Scorecard!B151
B26B26=Scorecard!B83
B27B27=Scorecard!B46
B28B28=Scorecard!B139
B30B30=Scorecard!B203
B31B31=Scorecard!B44
B32B32=Scorecard!B6
B34B34=Scorecard!B36
B35B35=Scorecard!B177
B36B36=Scorecard!B31
G4:J36G4=RANDBETWEEN(72,78)
K4:K36K4=SUM(G4:J4)
L4:L36L4=RANK(K4,\$K\$4:\$K\$203,1)

### Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

#### steve the fish

##### Well-known Member

=IF(COUNTIF(L:L,L4)>1,"T"&L4,L4)

#### steve the fish

##### Well-known Member
Although just looked at yours and that should be ok too.

#### wayne0881

##### Board Regular
Although just looked at yours and that should be ok too.
Hi thanks - I'll give it ago for sure but yea I thought the original code should work - I'm no excel expert though hence why i'm here )

I might also rewrite it on a new page - excel maybe playing up.

#### wayne0881

##### Board Regular
Although just looked at yours and that should be ok too.
Your code seems to be working perfectly, mine must have an obvious error in there somewhere - i'll keep randomising it but so far so good

#### dcardno

##### Well-known Member
You can do it with conditional formatting: test whether a number is equal to the number above - if so, apply a custom number format of "T0" (that's a "T" and a zero) - and any other formatting for colour or font. Apply the same test for whether a number is equal to the number below, and apply the same formatting - or perhaps, different formatting - the fist name listed is formatted normally, but shows up a T5 (etc), while the second (and on) name listed is shown as T5 but the cell is highlighted in some way.

Replies
0
Views
76
Replies
6
Views
287
Replies
1
Views
324
Replies
6
Views
251
Replies
2
Views
331

1,130,425
Messages
5,642,042
Members
417,251
Latest member
Dordrecht

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back