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.
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.