formula to identify top 3 times

E

Elle

I am putting together a score sheet for a cross country event. I need to find
out the formula that will work out what my to 3 times are.

Any ideas?
 
G

Gary''s Student

Assuming that the top three times are the lowest three times and that the
times are in column A, in B1 thru B3 enter:

=SMALL(A:A,1)
=SMALL(A:A,2)
=SMALL(A:A,3)
 
Top