Ranking data based on a second column data

[tcombest]

I have attached a pic of the sheet I am working on.

In this spreadsheet, column D indicates if the shooter is in the "H" hunter class, or "B" benchrest class. I want to rank the scores in column S based on the class that they are in. Is there a way I can enter a formula in column S that will do this without having to sort the table first? Note: The ranking will be from first to last, or 1 to whatever, based on the highest score in column R..