How to Determine 1st, 2nd & 3rd for a PWD

[Pete n PWD Land]

I have a spreadsheet that has some times for a Pinewood Derby (PWD). I would
like to determine from a range who came in 1st(figured out) 2nd, and 3rd.
I figured out 1 by using =MIN(B8:B19) command, but I don't know how to get
2nd and 3rd from the same range.

 

[Nick Hodge]

Pete

Answered elsewhere...check out the RANK function (No need to multi-post)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[CyberTaz]

Hi Pete-

If your records are arranged in consecutive columns and rows you can simply
click anywhere in the "time" column & click the Ascending Sort button on the
toolbar. That will not only put those three records at the top, but the rest
will be in order as well, first to last. You might also check out the
Data>Filter>AutoFilter feature if you just want to display the top (#) of
records.

Hope this is useful |:>)

 

[Myrna Larson]

Check out the SMALL functin in Help.