Determine 1st 2nd 3rd in PWD

P

Pete n PWD Land

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.
 
N

Nick Hodge

Pete

Check out the RANK function

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count occurances in a range. 5
How to Determine 1st, 2nd & 3rd for a PWD 3
Excel message box 5
Using excel to work out trifectas 0
Having difficulty copying and pasting on VBA 3
Time calculation 3
unable to get 2nd & 3rd column value from combobox 3
Copy and pasting ranges 3

Top