find ranking
 

I want to find ranking or position for my students in a class. So do i do
that in excell.

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.

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.