Ranking question (ties)

R

rozeltf

I'm keeping track of a golf tournament and I've got the RANK function
working the way I want the only thing I'd like to see is if there is a
tie, that the letter "t" be added. for example. Thanks for any help.

PLACE
1
2
3t
3t
3t
6
7
8t
8t
10
 
D

duane

something like this, where here I rank the value in cell b6 relative to
those in b5:b15

=IF(COUNTIF($B$5:$B$15,B6)=1,RANK(B6,$B$5:$B$15,1),RANK(B6,$B$5:$B$15,1)&"t")
 
D

davesexcel

rank vlookup

--------------------------------------------------------------------------------

=RANK(A2,$A$2:$A$22)&IF(OR(VALUE(RIGHT(RANK(A2,$A$
2:$A$22),2))={11,12,13}),"th",IF(OR(VALUE(RIGHT(RA
NK(A2,$A$2:$A$22)))={1,2,3}),CHOOSE(RIGHT(RANK(A2,
$A$2:$A$22)),"st","nd","rd"),"th"))
I tried it out, if there were ties it worked out the placements
accordingly
also when I entered 0 it gave the last placing the only time I got a NA
or error was when the cell was truely blank
Hope this helps

Here's a site you can use to check out Ranking

http://xldynamic.com/source/xld.RANK.html
 
G

Gary''s Student

If
1
2
3
3
3
6
7
8
8
10
are in column A, then in B2 put:
=IF(OR(A2=A3,A2=A1),A2&"t",A2) and copy down to see

2
3t
3t
3t
6
7
8t
8t
10
 
Top