Can these 2 following formulas be combind into one?
In C2 there is this
=RANK(B2,$B$2:$B$15)
In D2 there is this
=C2&IF(OR(MOD(C2,100)={11,12,13}),"th",CHOOSE(MIN(5,RIGHT(C2)+1),"th","st","nd","rd","th"))
Regards BVG
Can these 2 following formulas be combind into one?
In C2 there is this
=RANK(B2,$B$2:$B$15)
In D2 there is this
=C2&IF(OR(MOD(C2,100)={11,12,13}),"th",CHOOSE(MIN(5,RIGHT(C2)+1),"th","st","nd","rd","th"))
Regards BVG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks