Guidance needed wrkng with a wrksht

  • Thread starter Soahib Ahmed Quraishi
  • Start date
S

Soahib Ahmed Quraishi

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
 
B

Biff

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
 
Top