Select top 10 in a list

J

Joe Maldon

Hi,

I'm looking for a way to search a range in a list and pick the top 10
from that list. Once this has been done, I then need to copy the data
to another sheet elsewhere

For example, I have a sheet called "MainList" (http://
joemaldon.googlepages.com/), I would like to pick the top 10 from the
totals colum and then take each entry and copy into another sheet
called "Top10". So, copy ID, Name and Total to sheet called "Top10".
Also then add rank positions including the joint places.

Can anyone please offer a solution how this can be done please?

Note there are two entries with the same total so the top 10 would
actually consist of twelve entries. Hope that makes sense.

Many thanks.

Joe Maldon
 
A

Alexander Wolff

Import the data to excel (Row 2+) and give them field names above (Row 1).

Now: Data Autofilter Top10 (allows you to change from 10).

You now can just copy it elsewhere, because only filtered (=visible) rows
get copied.
 
P

Peo Sjoblom

In the future please refrain from multiposting to different newsgroups.


--


Regards,


Peo Sjoblom
 

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

Similar Threads


Top