Ap Rank ka function istimal kar sakte hain ye automatically numbers assign kar de ga.
For example agar ap k students k final marks B2 se B35 tak hain tu C2 m below formula lekhain aur copy down as far as required. Change references accordingly.
Code:
=RANK(B2,$B$2:$B$35)
Hope this will help you. Lekan aik chota sa masla ha rank function k sath. Agar kisi students k darmeyan tie ho yani number aik jese hon tu ye dono numbers ko aik e rank de ga lekan us k bad wale students k grader aik darga omit kar gai ga. Jis k leye formula thoda different ho ga. Agar aisa ha tu try this
Code:
=RANK(B2,$B$2:$B$35,0)+COUNTIF($B$2:$B$35,B2)-1
regards
Bookmarks