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.

MANY MANY THANKS Marcol & martindwilson.
I AM GRATFUL TO BOTH OF YOU.
I HAVE TRIED THE Marcol'S FORMULA IN MY EXCEL SHEET. IT'S FINE.
BUT THERE ARE FEW PROBLEMS ARISES. SOME STUDENTS HAVING D-VALUE 1 (ONE), GOT RANK BEFORE THE STUDENTS HAVING D-VALUE 0 (ZERO).
SIMILARLY SOME STUDENTS HAVING D-VALUE 2 (TWO), GOT RANK BEFORE THE STUDENTS HAVING D-VALUE 1 (ONE).
I HAVE MARKED THOSE STUDENTS & THEIR POSITION, NAME, D-VALUE ETC IN RED COLOUR.
PLEASE HELP.
THANK YOU.

THANKS A LOT Marcol.
YOUR WORKBOOK WORK NICE BUT STILL THERE ARE SOME ERRORS REMAIN.
THERE ARE SOME STUDENTS GOT LOWER RANK HAVING HIGHER MARKS FOR A PARTICULAR D-VALUE.

41 033 SRI. DIBAKAR GHOSH. 269 0
42 045 SRI. ABHIJIT NASKAR. 270 0
43 029 MISS. RANJANA MONDAL. 256 0
44 058 SRI. SARAJIT PRAMANIK 257 0


69 038 SRI. SOURAV SARKAR. 236 1
70 065 MISS. KABITA BAIN. 238 1

I HAVE MENTIONED THOSE ERRORS IN RED COLOR IN THE WORKBOOK.
PLEASE HELP.
THANK YOU AGAIN.

@ Martin
If you update your attachment in post #11 with my correction in post #10, then the results will match.

WONDERFUL.
HATS OF YOU Marcol. IT WORKS.
THANK YOU VERY MUCH.

NOW I HAVE TWO MORE QUERIES.
HOW TO ADD AUTO TAB FUNCTION HERE ? WHEN I GIVE THREE DIGIT NUMBER IN "MARKS OBTAINED" CELL THE CURSOR AUTOMATCALLY MOVE TO THE ADJACENT "D-GRADE" CELL (RIGHT TO "MARKS OBTAINED" CELL) & THEN WHEN I GIVE ONE DIGIT NUMBER IN "D-GRADE" CELL THE CURSOR AUTOMATCALLY MOVE TO THE NEXT BELOW "MARKS OBTAINED" CELL.
AND SO ON.

SECONDLY, WHEN I PUT 0 (ZERO) IN "MARKS OBTAINED" CELL THE CORRESPONDING 'NAME OF THE STUDENT' & IT'S ROLL GET RED COLOR (TEXT).
THANKS IN ADVANCE.

Thanks a Lot martindwilson Too.