Can't figure out the Function I need!


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

Advertisements

T

trip_to_tokyo

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.
 
S

slober

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
 
J

Jacob Skaria

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
 
Ad

Advertisements

T

trip_to_tokyo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top