Have you tried the Data > Filter > (Auto Filter or Advanced Filter) from
the data menu?
The Auto Filter has a selection for the Top 10.
Here is what Excel Help has to say on the Advanced Filter:
---------------
Filter a list by using advanced criteria
Your worksheet should have at least three blank rows above the list
that can be used as a criteria range. The list must have column
labels.
Select the column labels from the list for the columns that contain the
values you want to filter, and click Copy .
Select the first blank row of the criteria range, and click Paste .
In the rows below the criteria labels, type the criteria you want to
match. Make sure there is at least one blank row between the criteria
values and the list.
To see criteria examples, click .
Click a cell in the list.
On the Data menu, point to Filter, and then click Advanced Filter.
Show Me
To filter the list by hiding rows that don't match your criteria, click
Filter the list, in-place.
To filter the list by copying rows that match your criteria to another
area of the worksheet, click Copy to another location, click in the
Copy to box, and then click the upper-left corner of the area where you
want to paste the rows.
In the Criteria range box, enter the reference for the criteria range,
including the criteria labels.
To move the Advanced Filter dialog box out of the way temporarily while
you select the criteria range, click Collapse Dialog .
Tips
You can name a range Criteria, and the reference for the range will
appear automatically in the Criteria range box. You can also define the
name Database for the range of data to be filtered and define the name
Extract for the area where you want to paste the rows, and these ranges
will appear automatically in the List range and Copy to boxes,
respectively.
When you copy filtered rows to another location, you can specify which
columns to include in the copy. Before filtering, copy the column
labels for the columns you want to the first row of the area where you
plan to paste the filtered rows. When you filter, enter a reference to
the copied column labels in the Copy to box. The copied rows will then
include only the columns for which you copied the labels.