Formula to Rank

[Ecel Dumbo]

Hello,


Could you please suggest me a formula to rank data (1 ,2,3 ,5 based on the biggest to the least) in the attached worksheet. Problem here is there are empty spaces in between data which I dont want to count and which i dont want to delete as well. Thanks


http://speedy.sh/fzbGt/Formual-to-Rank-spaces-in-between-data.xls


Regards,

Excel Dumbo

 

[sdsurzh]

Hi,


Can you please try the below formula.


=IFERROR(RANK(B2,$B$2:$B$13,0),"")


Thanks,

Suresh Kumar S

 

[NARAYANK991]

Hi ,


Surely this can be taken care of by an IF statement ? Something like this :


=IF(B2="","",RANK(B2,$B$2:$B$13))


entered in C2 , and copied down , should do the job.


Narayan