Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find ranking
I want to find ranking or position for my students in a class. So do i do
that in excell. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
find ranking
One way is to use RANK (Check up this function in Excel's Help)
Briefly, to get you going ... Assume your student scores are listed in B2:B10 Place in C2: =RANK(B2,$B$2:$B$10) Copy C2 down to C10 This returns a descending order rank, ie highest score will be given a rank = 1 Place in D2: =RANK(B2,$B$2:$B$10,1) Copy D2 down to D10. This returns an ascending order rank, viz lowest score will be given a rank = 1 Duplicate scores (if any) will be given the same rank (Check up more on this in Excel's help) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Kumbu" wrote: I want to find ranking or position for my students in a class. So do i do that in excell. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
find ranking
I have a variety of formulas for ranking in lists. See
http://www.cpearson.com/excel/rank.htm. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Kumbu" wrote in message ... I want to find ranking or position for my students in a class. So do i do that in excell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ranking | Excel Worksheet Functions | |||
Ranking | Excel Discussion (Misc queries) | |||
How do I find best fit out of a set of options by ranking criteri | Excel Worksheet Functions | |||
Ranking | Excel Discussion (Misc queries) | |||
Ranking | Excel Discussion (Misc queries) |