Frank Kabel wrote...
see:
http://www.xldynamic.com/source/xld.RANK.html

How is this relevent to the OP's question? It's a long and overly
pedantic exposition of adding ordinal suffixes to cardinal ranks. And
it concludes with the redundant formula

=CHOOSE(AND(x<{11,12,13})*MIN(4,MOD(x,10))+1,"th" ,"st","nd","rd","th")

rather than the shorter

=CHOOSE(MIN(3,MOD((ABS(x-12)1)*x-1,10))+1,"st","nd","rd","th")

and
http://www.cpearson.com/excel/rank.htm

More to the point.


--
hgrove
------------------------------------------------------------------------
hgrove's Profile: http://www.excelforum.com/member.php...o&userid=11432
View this thread: http://www.excelforum.com/showthread...hreadid=274557