Formula for ranking
Posted by Bruce Chesser on October 16, 2001 1:57 PM
Question? There are approximately 100 to 150 students who take a series of 10 test, and each account for a percentage of the final grade. We have a spread sheet that when we insert the grade for each test it is incorporated into the final grade average. So you have 100 different averages, and a few that are the same. What I need is a formula that will calculate each individual standing in the class, such as: 5 of 100, 33 of 100, 69, of 100, etc, etc. Thank you in advance for your input.
Posted by Aladin Akyurek on October 16, 2001 2:14 PM
Bruce,
Have a look at the RANK function in Help.
=RANK(A1,$A$1:$A$100)
where A1 is the final grade average of the first student in your list and A1:A100 houses final grade averages of a class of 100 sudutents.
Aladin
Posted by Bruce on October 16, 2001 5:03 PM
Thanks Aladin: I tried that formula once before, and I know I am getting close as I recall having the same problem as I am having now, and forgot what the solution was. Using this formula I am getting #VALUE.
Posted by Dan on October 16, 2001 6:54 PM
Aladin has the correct code. How are you entering your formula on your sheet?
Posted by Bruce Chesser on October 17, 2001 7:23 AM
Yes I did, however still having problems. If you don't have a problem with it leave me your e-mail and I will send you a copy of the spread sheet.
Thanks for your imput!
Posted by Aladin Akyurek on October 17, 2001 8:47 AM
My e-mail address in the header, if you want me to have a look at your data.
Cheers,
Aladin
Posted by Bruce on October 17, 2001 9:21 AM
The formula works great! The problem was that as students dropped out their final average showed as #Value. Just added a 0 as thier grade and everything worked perfect. Will save a lot of work!!!
