Ranking question (ties)

[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

[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")

[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

[rozeltf]

Thanks for the help!

[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

--
Gary''s Student


"rozeltf" wrote:

>
> 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
>
>
> --
> rozeltf
> ------------------------------------------------------------------------
> rozeltf's Profile: http://www.excelforum.com/member.php...o&userid=33295
> View this thread: http://www.excelforum.com/showthread...hreadid=531189
>
>

[rozeltf]

Gary''s student - perfect, thanks