Formula to rank data where two values are the same

[Howardc]

I have a spreadsheet with various marks. I have tried to set up a formula to rank the marks, but where two marks are the same i get the same student name-see formulas B24:D28

It would be appreciated if you could assist in correcting the formula so that if two diffrent students get the same mark, it will display their names as well as there student numbers