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

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.

Pete

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Pete n PWD Land" wrote in message
...
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.

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
DataFilterAutoFilter feature if you just want to display the top (#) of
records.

Hope this is useful |:)

"Pete n PWD Land" wrote:

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.

Check out the SMALL functin in Help.

"Pete n PWD Land" wrote:

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.