Need help on ranking

Hi,

I have an excel workbook of marks for students with 4 worksheets and each worksheet contains approximately 3000 rows of data.

I am able to get some resolution on overall ranking of each worksheet without duplicates. However, I also need the ranking institute wise in the next column.

I am attaching a sample for better understanding. Could someone throw a small light on this?

Regards,

Kiran