Hello friends.
I'm trying to generate a ranking for a competition. It is organized by sectors (A, B, C...), and each sector has a similar number of positions (9, 9, 10, 10...).
The ranking should be created based on the weight obtained by each participant in each sector (higher weight, fewer points):
In case of a tie, I need to average the score obtained among the participants, for example, the cells marked in yellow correspond to averaging ranks 3, 4, and 5 (i.e., 4 points).
Additionally, the last scores for each sector are calculated based on the sector with the fewest positions (in this case, 9), and if any have more (10), the last-ranked participant should also be scored with a 9.
Could i create a calculated field that does all of this?
Thanks!!!
Thank you, romulo_torres. I have finally found the way to do it using the following formula in Google Sheets:
User | Count |
---|---|
17 | |
12 | |
5 | |
5 | |
5 |