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).
Hack up fake data and make a workbook with that.
I would approach it by putting all the variables on a sheet, with the variables ordered in the level of ranking required by the tiebreakers.
Then I would create a variable:
Probably you'd run it TABLE(down) (though that's what I would want to play with) and use the [index] value as the ranking value.