Calculation of positions in excel [Solved/Closed]

Mohsin - Jul 17, 2012 at 04:56 AM - Latest reply:  Dausayi
- Oct 12, 2016 at 04:52 AM
Hello
Hello, sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...i have students total marks.now I wanna get the position of the students i.e first , second, third etc. I will be glad and praiseworthy if u can help me out
...

See more 

12 replies

jessyrey 2 Posts Tuesday July 17, 2012Registration date July 17, 2012 Last seen - Jul 17, 2012 at 07:14 AM
-1
Thank you
to select a data toolbar you can see a sort button,, click it ,, that ask u for assending order or decending order... you select yourself what you want... the decending order will display the oder on decending...
thanks for helping
aquarelle 7183 Posts Saturday April 7, 2007Registration dateModeratorStatus May 25, 2018 Last seen - Jul 17, 2012 at 12:35 PM
-2
Thank you
Hi,

Well, I supposed that your data were something like that :
   
     A            B           C  
1 Students    Marks      Position  
2 Philippe       15           2  
3 Sam            19           1  
4 Jeny           12           3  
5 John           9            4  
6 Jane           8            5  



To have the student result position in the column C, try with this formula :
C2=RANK(B2,$B$2:$B$6) and drop down the formula on C column.

Best regards
"Pour trouver une solution à ses problèmes, il faut s'en donner la peine."
It works perfectly.
not works ...
because if the two same values are occur in the data i.e( 15,15 ), then the results missing ... hope you understand me.
44 ................. 2
43 ................. 3
42................. 5
41 ................. 7
41 ................. 7
42 ................. 5
43 ................. 3
45 ................. 1

here in the above example on ranking 4 and 6 are missing., because 3 is two times, 5 is also two times.
I'm Mr Lance, thank you very much for your assistance. what if i want the result to be the 1st, 2nd, 3rd, 4th etc format?
Yahaya Bashir Dausayi
My problem is that, i want the result of my students to be like this: 1st, 2nd, 3rd etc. I don't it to be like this:1, 2, 3, 4, 5 and soon.
thank you very much for your good help.