Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
=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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling hair out with VLOOKUP | Excel Worksheet Functions |