Hi,

Am Wed, 9 Dec 2015 10:13:36 -0800 (PST) schrieb Akash Maheshwari:

if 1 is displayed it should reflect 1st in the cell
if 2 is displayed it should reflect 2nd in the cell
if 3 is displayed it should reflect 3rd in the cell
if 4 is displayed it should reflect 4th in the cell
if 5 is displayed it should reflect 5th in the cell
if 6 is displayed it should reflect 6th in the cell
if 7 is displayed it should reflect 7th in the cell
if 8 is displayed it should reflect 8th in the cell

try:
=RANK(A20,$A$1:$A$20)&IF(RANK(A20,$A$1:$A$20)<4,CH OOSE(RANK(A20,$A$1:$A$20),"st","nd","rd"),"th")
or:
=RANK(A20,$A$1:$A$20)&VLOOKUP(RANK(A20,$A$1:$A$20) ,{1,"st";2,"nd";3,"rd";4,"th"},2,1)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional