Calculation of positions in excel [Solved/Closed]

Report
-
 Dausayi -
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
...

2 replies


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
Posts
7081
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
September 25, 2020
499
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.