formula to identify top 3 times

[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?

 

[Pete_UK]

Have a look at the SMALL function in XL Help.

Hope this helps.

Pete

 

[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)