Rank duplicates based on specific column value

HofkiCks

New Member
Joined
Feb 3, 2025
Messages
2
Office Version
  1. 365
Platform
  1. Windows
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?
Screenshot 2025-02-03 144010.png

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.
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Hi & welcome to MrExcel.
How about
Fluff.xlsm
ABCDEFG
1
2Player 1323833
3Player 24341111
4Player 3252922
5Player 4422834
6Player 5511755
Data
Cell Formulas
RangeFormula
E2:E6E2=SUM(B2:D2)
F2:F6F2=RANK.EQ(E2,$E$2:$E$6)
G2:G6G2=XMATCH(A2:A6,TAKE(SORT(A2:E6,{5,4},-1),,1))
Dynamic array formulas.
 
Upvote 0
Solution
Wonderfull! Works like a charm, and now I can even define other weights to judges with this solution.
 
Upvote 0

Forum statistics

Threads
1,226,218
Messages
6,189,693
Members
453,563
Latest member
Aswathimsanil

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top