I have set up a formula to assign a ranking by both # and $ using the
following table: A B C
46 Angie 16 $34,676.31
47 Bettye 16 $9,908.81
48 Felicia 10 $6,971.93
49 Gayle 28 $27,937.91
50 Jim 8 $1,575.39
51 Judy 15 $23,055.00
52 Les 1 $75.00
53 Linda 8 $4,169.00
54 Manny 11 $6,380.82
55 Perlene 9 $1,630.00
56 Rachael 1 $150.00
57 Sandra 10 $4,255.00
58 Scott 6 $6,122.95
59 Wade 12 $6,636.37


In the event of a tie, such as between Angie and Bettye, is it possible to
have Excel refer to the dollar amounts as a tie-breaker so-to-speak?