In EXCEL 2007:-

1. Highlight the range (for example A1 to F10).

2. Data / Filter / drop down arrows will appear in, for example, row 1.

3. Click the arrow appearing in column F and select:-

Sort Smallest to Largest.

There is your answer.

If my comments have helped please hit Yes.



"slober" wrote:

Basically..

Column A is a list of names

Column F is the total amount of hours practice the named person has done

I want a Fuction which automatically tells me the top 5/10 names of those
who have done the most practice.

Is this possible? and how do i go about it?


Thanks!!