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 modify karna ho ga. agar aisa ho to bataye ga. Test it
regardds
Bookmarks