=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=516752