Results 1 to 16 of 16

Rank making for students

Threaded View

  1. #1
    Registered User
    Join Date
    07-10-2012
    Location
    INDIA
    MS-Off Ver
    Excel 2010
    Posts
    6

    Rank making for students

    Rank making formula for students :-
    there are ten sudents roll from 1 to 10. I want to make their ranks according to "marks obtained" with considering the "d-value".
    First the rank will be done for those sudents having "d-value" 0 (zero) and according to "marks obtained" from highest marks to lowest.
    Next the rank will be done for those sudents having "d-value" 1 (one) and according to "marks obtained" from highest marks to lowest.
    Next the rank will be done for those sudents having "d-value" 2 (two) and according to "marks obtained" from highest marks to lowest.
    Next the rank will be done for those sudents having "d-value" 3 (three) and according to "marks obtained" from highest marks to lowest and so on.

    If there any tie (duplicate) in any case e.g having "d-value" 0, 1, 2 or 3 the rank will be done according to roll i.e whose roll is minimum will be in lower rank.

    Roll name of the students marks obtained d-value rank as
    1 sri prosenjit sarkar 618 0 1
    3 sri bapi mondal 316 0 5
    5 miss tania khatun 400 0 3
    7 miss kabita bain 238 1 7
    9 sri chiranjit mondal 183 1 8
    2 miss sonali biswas 316 0 4
    4 sri chetan lala 185 2 9
    6 miss rupa roy 415 0 2
    8 miss sana biswas 310 0 6
    10 sri rabi hasan 285 3 10

    please provide the necessary formula for rank making as shown here. The formula will reside in rank cells.
    Thanks in adance. Kindly help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1