Ranking with RANK and SUMPRODUCT based on Two Value Columns

I am trying to rank based on two value columns - (Aggregate and Raw Score) - such that it should rank by Aggregate (Column B), then by Raw Score (Column C).
In the data, the least Aggregate should be ranked first and highest aggregate should be last.

However, where two or more persons have same Aggregate, then the highest Raw Score should be used to separate them.
I used the formula below:

=RANK(C2,$C$2:$C$130)+SUMPRODUCT(--($C$2:$C$130=$C2),--(B2>$B$2:$B$130))&MID("thstndrdth",MIN(9,2*RIGHT(RANK(C2,$C$2:$C$130))*(MOD(RANK(C2,$C$2:$C$130)-11,200)>2)+1),2)

but, it seems some persons with higher Aggregates with higher Raw Score have been ranked before those with least Aggregate.

Any help to rank them by least Aggregate then by highest Raw Score.

Data attached

Thanks a lot.
The ranking is done with a perfect separation of tie aggregates
But the "st th nd rd" suffixes are messed up.
I think the problem is with second part of the function:

&MID("thstndrdth",MIN(9,2*RIGHT(RANK(C2,$C$2:$C$130))*(MOD(RANK(C2,$C$2:$C$130)-11,200)>2)+1),2)

Can you please help?

Thanks in advance

Thanks in a million, BO_RY

It works perfectly EXCEPT for 111, 112 and 113 positions, which pick 111st, 112nd and 113rd instead of 111th, 112th and 113th

I have no idea on how to solve this.

Any solution, please!

Thanks

Change:

=SUMPRODUCT(--(GRADE*1000-RSCORE<B2*1000-C2))+1&MID("thstndrdth",MIN(9,2*RIGHT(SUMPRODUCT(--(GRADE*1000-RSCORE<B2*1000-C2))+1)*(MOD(SUMPRODUCT(--(GRADE*1000-RSCORE<B2*1000-C2))+1-11,200)>2)+1),2)

to:

=SUMPRODUCT(--(GRADE*1000-RSCORE<B2*1000-C2))+1&MID("thstndrdth",MIN(9,2*RIGHT(SUMPRODUCT(--(GRADE*1000-RSCORE<B2*1000-C2))+1)*(MOD(SUMPRODUCT(--(GRADE*1000-RSCORE<B2*1000-C2))+1-11,100)>2)+1),2)

Thanks so so much, Bo_Ry, Phuocam and kvsrinivasamurthy, for your prompt, perfect and life-saving solutions.
In fact, you guys are geniuses.

It works perfectly as I really wanted.

Many thanks.