Ranking Duplicate Data - Golf Leaderboard

[wayne0881]

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

PGA Leaderboard.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
2		74
3				Total	Thru	Round	R1	R2	R3	R4	Strokes
4	192	Justin Harding	1	-8			72	72	72	72	288	1
5	93	Martin Laird	2	-7			72	72	73	72	289	2
6	186	Sean Crocker	3	-6			73	73	72	72	290	3
7	138	Keegan Bradley	T4	-4			74	72	74	72	292	4
8	188	Min Woo Lee	T4	-4			73	74	73	72	292	4
9	111	Jason Scrivener	T4	-4			72	74	74	72	292	4
10	200	Adrian Meronk	T7	-3			73	74	74	72	293	7
11	191	Wil Besseling	7	-3			74	73	72	74	293	7
12	161	Tyler Duncan	7	-3			75	72	72	74	293	7
13	47	Jason Day	7	-3			73	74	73	73	293	7
14	105	Michael Thompson	11	-2			74	74	73	73	294	11
15	11	Rory McIlroy	11	-2			75	73	72	74	294	11
16	163	Brandon Wu	11	-2			74	75	72	73	294	11
17	87	Sam Burns	11	-2			73	73	72	76	294	11
18	198	Bud Cauley	11	-2			73	77	72	72	294	11
19	75	Branden Grace	11	-2			72	72	73	77	294	11
20	153	Mark Hubbard	17	-1			75	72	76	72	295	17
21	70	Rickie Fowler	17	-1			76	74	72	73	295	17
22	92	Francesco Molinari	17	-1			73	72	77	73	295	17
23	35	Kevin Kisner	17	-1			73	76	74	72	295	17
24	60	Sebastian J Munoz	17	-1			73	72	75	75	295	17
25	147	Lucas Glover	17	-1			73	73	73	76	295	17
26	79	George Coetzee	23	E			72	78	72	74	296	23
27	42	Robert MacIntyre	T23	E			72	76	75	73	296	23
28	135	Mike Lorenzo-Vera	T23	E			74	74	72	76	296	23
29	63	Erik van Rooyen	23	E			73	72	76	75	296	23
30	199	Brian Gay	23	E			75	73	74	74	296	23
31	40	Shane Lowry	T23	E			78	72	74	72	296	23
32	2	Jon Rahm	T23	E			77	73	74	72	296	23
33	166	Marc Warren	T23	E			75	75	74	72	296	23
34	32	Jason Kokrak	T23	E			76	73	75	72	296	23
35	173	Dean Burmester	23	E			76	75	73	72	296	23
36	27	Cameron Smith	23	E			77	72	73	74	296	23
Sheet1

Cell Formulas
Range	Formula
B4	B4	=Scorecard!B196
C4:C36	C4	=IF(OR(L4=L5,L4=L3),"T"&L4,L4)
D4:D36	D4	=IF(SUM(G4:J4)-(COUNTA(G4:J4)*$B$2)=0,"E",(SUM(G4:J4)-(COUNTA(G4:J4)*$B$2)))
B5	B5	=Scorecard!B97
B6,B8,B11,B18	B6	=Scorecard!B190
B7	B7	=Scorecard!B142
B9	B9	=Scorecard!B115
B10	B10	=Scorecard!B204
B12	B12	=Scorecard!B165
B13,B29	B13	=Scorecard!B51
B14	B14	=Scorecard!B109
B15	B15	=Scorecard!B15
B16	B16	=Scorecard!B167
B17,B22	B17	=Scorecard!B91
B19	B19	=Scorecard!B79
B20,B33	B20	=Scorecard!B157
B21	B21	=Scorecard!B74
B23	B23	=Scorecard!B39
B24	B24	=Scorecard!B64
B25	B25	=Scorecard!B151
B26	B26	=Scorecard!B83
B27	B27	=Scorecard!B46
B28	B28	=Scorecard!B139
B30	B30	=Scorecard!B203
B31	B31	=Scorecard!B44
B32	B32	=Scorecard!B6
B34	B34	=Scorecard!B36
B35	B35	=Scorecard!B177
B36	B36	=Scorecard!B31
G4:J36	G4	=RANDBETWEEN(72,78)
K4:K36	K4	=SUM(G4:J4)
L4:L36	L4	=RANK(K4,$K$4:$K$203,1)

 

[steve the fish]

How about:

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

 

[steve the fish]

Although just looked at yours and that should be ok too.

 

[wayne0881]

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]

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]

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.