=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