formula to identify top 3 times
 

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?

formula to identify top 3 times
 

Have a look at the SMALL function in XL Help.

Hope this helps.

Pete

On Oct 24, 4:18*pm, Elle wrote:
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?

formula to identify top 3 times
 

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)

--
Gary''s Student - gsnu200809