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..

[rylo]

Hi

S104: =SUMPRODUCT(--($D$104:$D$108=D104),--($R$104:$R$108<R104))+1

Copy down to S108.

Or if you want to include the class code with the ranking then how about:
S104: =D104&SUMPRODUCT(--($D$104:$D$108=D104),--($R$104:$R$108<R104))+1

HTH

rylo

[tcombest]

rylo,

I saw that code in a couple other places on this site, but I didn't think it was what I needed. I put it in my sheet and it worked perfectly. I really appreciate your assistance.