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

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


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=531189

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


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=531189

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

Thanks for the help!


--
rozeltf
------------------------------------------------------------------------
rozeltf's Profile: http://www.excelforum.com/member.php...o&userid=33295
View this thread: http://www.excelforum.com/showthread...hreadid=531189

Gary''s student - perfect, thanks


--
rozeltf
------------------------------------------------------------------------
rozeltf's Profile: http://www.excelforum.com/member.php...o&userid=33295
View this thread: http://www.excelforum.com/showthread...hreadid=531189