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!!

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!!

I don't want to SORT them, I want it to list the names at the bottom... its
a massive list, I don't want to re-order it, just take the top 5 names

"trip_to_tokyo" wrote:

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!!

Try the below formula and copy/drag down as required for names in descending
order (highest on top)

=INDEX(A:A,MATCH(LARGE(F:F,ROW(A1)),F:F,0))

If this post helps click Yes
---------------
Jacob Skaria


"slober" wrote:

I don't want to SORT them, I want it to list the names at the bottom... its
a massive list, I don't want to re-order it, just take the top 5 names

"trip_to_tokyo" wrote:

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!!

Try the RANK function then (in EXCEL 2007).



"slober" wrote:

I don't want to SORT them, I want it to list the names at the bottom... its
a massive list, I don't want to re-order it, just take the top 5 names

"trip_to_tokyo" wrote:

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!!