Ranking Duplicate Data - Golf Leaderboard

wayne0881

Board Regular
Joined
Nov 2, 2009
Messages
93
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

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,388
Office Version
  1. 365
Platform
  1. Windows
How about:

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

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,388
Office Version
  1. 365
Platform
  1. Windows
Although just looked at yours and that should be ok too.
 

wayne0881

Board Regular
Joined
Nov 2, 2009
Messages
93
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.
 

dcardno

Well-known Member
Joined
Nov 20, 2002
Messages
536
Office Version
  1. 2013
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,687
Messages
5,637,832
Members
416,984
Latest member
dee10

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top