Hi Team,

Greetings!!

Require a solution.

I have used a Rank Formlua which displays 1-8 Ranks.

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

Can someone give me the solution for the same.

Awaiting for your response.

Best Regards

Akash Maheshwari

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

Thanks a tonn Mr. Claus.

Rgds

Akash Maheshwari

On Wednesday, December 9, 2015 at 11:57:56 PM UTC+5:30, Claus Busch wrote:
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