|I played with this a bit and it seems like Pearson's section related to "Double Ranking And Tie Breaking" should work with one minor change.|
At Chip Pearson's site, the tie breaking is based on using the highest value in both the main score and the tie breaking score to find the winner. In the OP's situation, the main score is based on the highest value, but the tie breaker is based on the lowest value.
It appears that the formula for the "composite score" needs to be changed so that the second term is subtracted from the first term instead of added:
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.