Rank duplicates based on specific column value

[HofkiCks]

Have been unable to find this somewhere, so looking for help.

I am creating a Judging template where several judges will fill in scores. Whenever a duplicate value with the RANK formula is shown the score of a specific judge (f.i. Judge 3) needs to determine the definitve Rank numer. Is this possible?

The RANK example above has two duplicates (3) and should Rank the value of Player 4 to 4 since Judge 3 has given a higher score to Player 1 as opposed to Player 4. Please advise.

 

[Fluff]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	A	B	C	D	E	F	G
1
2	Player 1	3	2	3	8	3	3
3	Player 2	4	3	4	11	1	1
4	Player 3	2	5	2	9	2	2
5	Player 4	4	2	2	8	3	4
6	Player 5	5	1	1	7	5	5
Data

Cell Formulas
Range	Formula
E2:E6	E2	=SUM(B2:D2)
F2:F6	F2	=RANK.EQ(E2,$E$2:$E$6)
G2:G6	G2	=XMATCH(A2:A6,TAKE(SORT(A2:E6,{5,4},-1),,1))
Dynamic array formulas.

 

[HofkiCks]

Wonderfull! Works like a charm, and now I can even define other weights to judges with this solution.

 

[Fluff]

You're welcome & thanks for the feedback.