Excel Query

I'm not clear if you want to do this manually for a one-time deal, or if you need it automated with VBA. Assuming the former, let's assume your data is in column A from row 2 to row 21 (20 rows of data but you only need the top 10 times).

In cell B2, enter the formula
=RANK(A2,$A$2:$A$21)

Then sort B2:B21 in descending order, and the top 10 times will be in order, in the cells from B2:B11.

Is this what you are looking for?

Tom Urtis

One follow-up

The sort range should be A2:B21, but of course if you only need the 10 fastest times you can skip the rank formula and sort descending the times (your actual data).

There's probably more to your request but hopefully this is a start.

Tom U.

: I am trying to run a query in Excel that shows the top 10 times for a number of different swim events. I can get the query so that it lists all of the times but I only want to see the 10 fastest... is there any way to do this? Could you please help and e-mail me if you know? Thank's a lot!

Auto Filter

Brett
I assume you have a list of names and corresponding times. You can auto filter the list, then click on the down arrow in the times column and select top 10. In the dialogue box that comes up, choose bottom instead of top. You can choose any number between 1 and 500 to display.
HTH
Richard