Multiple Criteria Ranking Help needed

Hello, I have a problem with the ranking system.

Below are some examples of data.

D	E	F	Rank
46	3	3
45	5	3
44	4	12
42	2	9
56	1	17
64	3	17
23	3	17
64	5	17

D - Score
E - Selected Number
F - Group Number

I would like it to be ranked in group; meaning if it's in Group 17 (Column F), I want it to be ranked by, first, Seleceted Number (column E; from smallest to largest), and then by Score (column D, from lagrest to smallest)

For better understanding, look at it like a university application system where you can choose multiple university (F) in multiple ranks (E) with the scores (D)

I tried some various method with sumproduct, rank, countifs but sadly unsuccessful. So, I decided to ask for some help here.

Thank you in advance. X

Sawaddee

Please try at D2 and copy down

=SUMPRODUCT(--(C2*10^8-B2*1000+A2<$C$2:$C$9*10^8-$B$2:$B$9*1000+$A$2:$A$9))+1

If this not correct, please mock up manual answer at column D.

In D2 then cop down.

=SUMPRODUCT(($C$2:$C$9=$C2)*((($B$2:$B$9)+($A$2:$A$9*10^-5))<($B2+$A2*10^-5)))+1

Then perhaps:

Please Login or Register  to view this content.

WBD

Please try D2

=SUMPRODUCT(($C$2:$C$9=C2)*(($B$2:$B$9*10^5-$A$2:$A$9)<B2*10^5-A2))+1

Formula revised

=SUMPRODUCT(($C$2:$C$9=$C2)*((($B$2:$B$9)-($A$2:$A$9*10^-5))<($B2-$A2*10^-5)))+1