software

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 quot;tquot; be added. for example. Thanks for any help.

PLACE
1
2
3t
3t
3t
6
7
8t
8t
10--
rozeltf
------------------------------------------------------------------------
rozeltf's Profile: www.excelforum.com/member.php...oamp;userid=33295
View this thread: 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)amp;quot;tquot;)--
duane------------------------------------------------------------------------
duane's Profile: www.excelforum.com/member.php...oamp;userid=11624
View this thread: www.excelforum.com/showthread...hreadid=531189
rank vlookup

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

=RANK(A2,$A$2:$A$22)amp;IF(OR(VALUE(RIGHT(RANK(A2,$A$
2:$A$22),2))={11,12,13}),quot;thquot;,IF(OR(VALUE(RIGHT(RA
NK(A2,$A$2:$A$22)))={1,2,3}),CHOOSE(RIGHT(RANK(A2,
$A$2:$A$22)),quot;stquot;,quot;ndquot;,quot;rdquot;),quot;thquot;))
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

xldynamic.com/source/xld.RANK.html--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=531189If
1
2
3
3
3
6
7
8
8
10
are in column A, then in B2 put:
=IF(OR(A2=A3,A2=A1),A2amp;quot;tquot;,A2) and copy down to see

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

--
Gary''s Studentquot;rozeltfquot; wrote:

gt;
gt; I'm keeping track of a golf tournament and I've got the RANK function
gt; working the way I want the only thing I'd like to see is if there is a
gt; tie, that the letter quot;tquot; be added. for example. Thanks for any help.
gt;
gt; PLACE
gt; 1
gt; 2
gt; 3t
gt; 3t
gt; 3t
gt; 6
gt; 7
gt; 8t
gt; 8t
gt; 10
gt;
gt;
gt; --
gt; rozeltf
gt; ------------------------------------------------------------------------
gt; rozeltf's Profile: www.excelforum.com/member.php...oamp;userid=33295
gt; View this thread: www.excelforum.com/showthread...hreadid=531189
gt;
gt;


Thanks for the help!--
rozeltf
------------------------------------------------------------------------
rozeltf's Profile: www.excelforum.com/member.php...oamp;userid=33295
View this thread: www.excelforum.com/showthread...hreadid=531189
Gary''s student - perfect, thanks--
rozeltf
------------------------------------------------------------------------
rozeltf's Profile: www.excelforum.com/member.php...oamp;userid=33295
View this thread: www.excelforum.com/showthread...hreadid=531189