Rank function

  • Thread starter Thread starter Nasrulla Jameel
  • Start date Start date
N

Nasrulla Jameel

Hi,
Look at this,these are the marks obtained by different
students,for instance.
Jim 76
Bob 76
Jerry 59
Tom 34
The problem is when we use the Rank formula to calculate
the position of each student, it show that Jim and Bob at
the 1st place and Jerry at the 3rd place and Tom at the
4th place.
But I want a way to calculate Jerry in the 2nd place and
Tom at the 3rd place. We don't ommit a position in classes
here.
So is there any solution.
Hoping for a help.
bye
 
A B C D
1 Jim 76 76 1
2 Bob 76 1
3 Jerry 59 59 2
4 Tom 34 34 3

C1: =IF(COUNTIF(B$1:B1,B1)>1,"",B1)
D1: =RANK(B1,C$1:C$4)
 
Back
Top