Okay.....I have a ranked column of numbers from which there might be a tie.
In order to break the tie I have three tie-breaking conditions (tie-breaker
#1, tie-breaker #2, and tie-breaker #3). The rank is from lowest to highest
(smaller is better) BUT the tie-breaking conditions are from highest to
lowest (a larger number is better). I'd like to find a way, without using
VB, to create a "tie breaking rank" that applies the conditions of the three
tie-breakers in order to rank the original range of values; the tied ones and
the unique ones.

Below is a sample set of values:

Total Rank TB1 TB2 TB3 My Wish
170 10 0 2 0 10
122 7 3 2 1 7
96 6 1 0 1 6
72 3 3 2 2 3
14 1 7 10 1 1
78 4 3 3 4 4
69 2 4 1 4 2
78 4 1 1 4 5
128 9 1 1 1 9
122 7 3 0 3 8


Also, I do not want to base the new ranking on the original ranking as I
have some formatting and such within those cells that I do not want to
change. So the new ranking needs to be based on the "total" and the three
tie breaking conditions. I included the "my wish" column for what I hope the
new formula does for me.....

Hope someone can help!

Robert.