Determine 1st 2nd 3rd in PWD
 

I have a spreadsheet that has some times for a Pinewood. 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.

Determine 1st 2nd 3rd in PWD
 

Pete

Check out the RANK function

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


"Pete n PWD Land" <Pete n PWD wrote in
message ...
I have a spreadsheet that has some times for a Pinewood. 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.