Try:
Formula: copy to clipboard
=RANK($B2,$B$2:$B$9,0)&IFERROR(CHOOSE(RANK($B2,$B$2:$B$9,0),"st","nd","rd"),"")