1 Reply Latest reply on Mar 29, 2018 1:06 PM by Joe Oppelt

    Multiple tie-breaking rules

    Thurston Powers

      Hello,

       

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

       

      Best,

        • 1. Re: Multiple tie-breaking rules
          Joe Oppelt

          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:

           

          INDEX()

           

          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.