I had in a column total of a particular grade, i want to give postions to
them such as 1st, 2nd, 3rd so on. Now if iam using RANK function and if two
totals r same it shows GRade 1st for bth of them and eleminting grade 2nd
shows grade 3rd but my requirement is to display all grades, if had same
totals then it should not skip any grade frm middle.
I would be thankful 2 u pls show me a solution 2 this
with regards
sohaib ahmed
place: jeddah
day: saturday 28, 2006

Hi!

Assume your grades are in the range A2:A11.

Enter this formula as an array using the key combo of CTRL,SHIFT,ENTER in B2
and copy down:

=SUM(IF(A2<$A$2:$A$11,1/COUNTIF($A$2:$A$11,$A$2:$A$11)))+1

Biff

"Soahib Ahmed Quraishi" <Soahib Ahmed
wrote in message ...
I had in a column total of a particular grade, i want to give postions to
them such as 1st, 2nd, 3rd so on. Now if iam using RANK function and if
two
totals r same it shows GRade 1st for bth of them and eleminting grade 2nd
shows grade 3rd but my requirement is to display all grades, if had same
totals then it should not skip any grade frm middle.
I would be thankful 2 u pls show me a solution 2 this
with regards
sohaib ahmed
place: jeddah
day: saturday 28, 2006