I'm tracking Nascar stats in a workbook consisting of several sheets. I'm manually entering all data consisting of drivers starts, finishes, wins, etc. The issue I'm having is ranking the drivers by several categories, one beings laps led. The formulas I have seem to work with the exception that when two or more drivers have led the same number of laps, it lists one of the drivers twice. Right now, as an example, one charts reads:

Rank Driver # Laps Led
17 Sam Hornish 36
18 Marcos Ambrose 35
18 Marcos Ambrose 35
20 AJ Almendinger 33

At this point in the season M Ambrose and M Kenseth are tied for leading 35 laps. I would like the 3rd name in the list to read M Kenseth.

On my sheet I have column B setup with drivers names, column C with laps led. My Laps leaders charts consists of 4 columns. The 1st column (AD) is for whose led most laps (descending order) with formula: =IF(AF2=0,"",RANK(AF2,$AF$2:$AF$21)) - 2nd column is name of driver (AE) with formula =INDEX(B:B,MATCH(LARGE($C:$C,ROWS($A$1:A$1)),$C:$C ,0)) - 3rd column (AF) lists total laps led & formula =INDEX(C:C,MATCH(LARGE($C:$C,ROWS($A$1:A$1)),$C:$C ,0)) - 4th & final column I put in what I thought might be a tiebreaker column (AG) with formula =IF(C2="","",C2+ROW()/10^10.

I'm not having any luck with the formulas relisting the drivers names properly. I don't know if I'm overdoing it with the formulas that I have. I'm thinking I might need to use the CounIF function but I'm so lost right now I'm not sure How it needs to be used.

Any help would be greatly appreciated.

Doug