G Guest Feb 27, 2007 #1 I want to find ranking or position for my students in a class. So do i do that in excell.
G Guest Feb 27, 2007 #2 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)
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)
C Chip Pearson Feb 28, 2007 #3 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)
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)
