Conditional Ranking - rank scores depending on a text value

[PNY80]

Hello,

In a worksheet, I would like to rank people's scores (in descending order) but only if their associated status is "Move forward". For the other statuses of "Proceed with Caution" and "Do not Proceed", they'd be ranked after and listed at the bottom.

Please help!

Thank you!

 

[joemeshuggah]

assuming A2:A10 show status and B2:B10 show scores, this in C2:C10 should rank each status based on score
=SUMPRODUCT(--($A$2:$A$10=A2),--(B2<$B$2:$B$10))+1

 

[PNY80]

Thank you! Worked like a charm