OK, try this:

Enter this formula in H3:

=MIN(D3:D21)

Enter this formula G3:

=INDEX(B3:B21,MATCH(MIN(D3:D21),D3:D21,0))

Those will return the name and the lowest time.

Now, enter this array formula** in H4:

=MIN(IF((ISNA(MATCH(B$3:B$21,G$3:G3,0)))*(D$3:D$21 H3),D$3:D$21))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

Enter this formula in G4

=INDEX(B$3:B$21,MATCH(H4,D$3:D$21,0))

Select both G4 and H4 and copy down as needed.

Format the time cells as desired.

If there are ties (duplicate times) then this will get *really* complicated!


--
Biff
Microsoft Excel MVP


"thscc1659" wrote in message
...
I've figured out how to do Top 10 by class, I just need Top 10 list
excluding
multiple best times. Thanks for the help.