I would like to dynamically rank a list of changing values. I have attached an excel worksheet that has a hypothetical example as well as my current work-around. The problem with my work-around is that it works using a rand() number as a tie-breaker, but the ideal method should actually use an alphabetical sort when there is a conflict. Besides being more logical, an added benefit is that the ranks will not be volatile as there is a fixed tie-breaker and not a constantly changing random variable.
Do anyone know if there is a way to do this using the more ideal method?