I was wondering if anyone has had to deal with multiple tie-breaking rules for the RANK function. For example, I have to create unique ranks that follow the following logic
Rank a state by the average of all variable ranks If there is a tie, the winner has a value of 1 for variable A If there is still a tie, the winner has a lower value for variable B If there is still a tie, the winner has a lower value for variable C
How do you create these sorts of tiered tie breaking rules? Can you?
PS: I apologize for not including the workbook, but I can't provide the data publicly (yet).