Ranking by certain criteria

In my worksheet I have a tie for high score and use a tie breaker to determine winner. Tie breaker is number closest to another number (higher or lower ) . However, If the Tie breaker is 36 and exactly in between the high scorers tie breaker (33 and 39) I want the lower tie breaker to be the winner. In my formula, if the number falls exactly in between it will rank the tied high scorers by alphabetical order of player name. Attached is small file to show what i have..... my formula is in my tie breaker helper column "F3"

I would appreciate any help..

Welcome to the Board.

I wonder if perhaps you could do the following...

Revise tie_rank such that:

F3: =$B3+(0.1001-(ABS($C$12-$C3)/1000))+(SIGN($C$12-$C3)/10000)
copied down

Your rank then becomes straight forward I think:

E3: =RANK($G3,$G$3:$G$9)
copied down

The rank formula in F should ensure the closer the match the greater the value... the SIGN addition ensures that where the match is equal but sign is unequal (33/39 -> 36-33(1) / 36-39(-1)) the lower number generates the higher value... if you change the tie breaker from 36 to 37 you should see the Ranking adjusts appropriately.

You may choose to adjust E to account for multiple instances of the same score & tie_breaker variance (of the same sign)