Rating 1 to 10

[Kevin Lin]

Hi All,

Would someone please teach me how to input a formula that
could rate students grade. For example I got 10 students
and one of the student got 100 points is rated as no. 1
and 98 points is rated as no. 2 etc...

A B C
NAME POINTS RATING
Mike 75 3
John 60 5
Leon 100 1
Sam 98 2
Frank 74 4

Thank you,
Kevin

 

[Guest]

Hi All,

Would someone please teach me how to input a formula that
could rate students grade. For example I got 10 students
and one of the student got 100 points is rated as no. 1
and 98 points is rated as no. 2 etc...

A B C
NAME POINTS RATING
Mike 75 3
John 60 5
Leon 100 1
Sam 98 2
Frank 74 4

Thank you,
Kevin

--------------------------------------

The simplest thing is to just sort everything on column B, then put the
ratings in column C from 1..10.

After that you can leave things as they are or resort everything by
column A if you want it alphabetical.

Bill

 

[Bob Phillips]

=RANK(B1,$B$1:$B$10)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Peo Sjoblom]

What about ties? Assume Sam and Leon both had 100, what rank would you give
Mike? 3 or 2 (in sports competitions he would get the bronze thus 3) if so
use

=RANK(B2,$B$2:$B$6)


if you want Mike to get 2 when SAm and Leon both had a top tie use

=SUM(IF($B$2:$B$6>B2,1/COUNTIF($B$2:$B$6,$B$2:$B$6),0))+1

entered with ctrl + shift & enter

both formulas should be copied down

 

[Myrna Larson]

IMHO, the "simplest" thing is to use the RANK function <g>.

 

[Guest]

IMHO, the "simplest" thing is to use the RANK function <g>.

Sounds good to me! Somehow I'd never come across that one. Thanks.

Bill