'How to rank teams in google sheets based on two columns?
I have a spreadsheet with teams I want to rank. I have two columns - the first one is the main criteria teams should be ranked by, and the second one should be a tie-breaker when the first one is equal. If values in both columns are equal, teams should share the places. So, basically what I try to achieve is at least to rank teams based on two columns like in the "Kinda ok outcome" column. I've tried to do this using the built-in RANK function, but it only works with one column. In the best-case scenario, if it's even possible, I would like to format ranked places in a manner provided in the "Perfect outcome" column.
Solution 1:[1]
For this work, I recommend using a simpler mode, which would be the function SORT:
=SORT(A2:E15,2,FALSE,3,FALSE)
Your region seems to use ; instead of , so in your specific case it would look like this:
=SORT(A2:E15;2;FALSE;3;FALSE)
The result is this:
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Digital Farmer |