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