You could make a new total by adding those tie-breakers to the current
total. As they operate highest to lowest, you should subtract them
from the maximum within the range, i.e.:

=A2 + (MAX(C$2:C$11)-C2) + (MAX(D$2:D$11)-D2) + (MAX(E$2:E$11)-E2)

Copy this down a helper column, then apply your rank formula to this.
If your tie-breakers have different weights, then you can multiply
them by some weighting factor, eg:

=1000*A2 + 100*(MAX(C$2:C$11)-C2) + 10*(MAX(D$2:D$11)-D2) + (MAX(E$2:E
$11)-E2)

Hope this helps.

Pete

On Oct 14, 1:22*am, Robert wrote:
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.