Can't figure out the Function I need!

  • Thread starter Thread starter slober
  • Start date Start date
S

slober

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.
 
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
 
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
 
Try the RANK function then (in EXCEL 2007).



slober said:
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
Click to expand...
 
Back
Top