Excel 2007 : Tie-breakers in Excel

Hello,

I have searched extensively for tie breakers but have yet to find something that works for my workbook.

On my sheet the first tab is for results. On the second sheet, the area in grey is where I use my ranking formulas. It's very important that the area inside the white stays intact without having to insert cells to make updating this file very simple.

Where I am running into difficulty is the ranking of the three metrics, Margin %, UPG %, and Discount %. I can't get consistent, sequential results. It seems like ranks are skipped or tied, which forces me to go back and manually calculate or adjust the correct value.

Any help on how to make this more efficient would be greatly appreciated.