Rating 1 to 10
 

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

Kevin Lin wrote:
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

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

--

HTH

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


"Kevin Lin" wrote in message
...
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

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$6B2,1/COUNTIF($B$2:$B$6,$B$2:$B$6),0))+1

entered with ctrl + shift & enter

both formulas should be copied down



--

Regards,

Peo Sjoblom




"Kevin Lin" wrote in message
...
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

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

On Tue, 01 Mar 2005 11:50:44 -0500, "Bill Martin -- (Remove NOSPAM from
address)" wrote:

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

Myrna Larson wrote:
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