Select top 10 in a list
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 |
Select top 10 in a list
You could use an autofilter and choose the top 10, the filtered list can
then be copied. Record macro if you need the code to do this. -- Regards, Nigel "Joe Maldon" wrote in message ups.com... 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 |
Select top 10 in a list
Yes can do that but it's not really what i want to do. I need to copy
and paste the data to another sheet and then show joint ranking as well as per http://joemaldon.googlepages.com/ Auto filter will only filter 10 items whereas my example should display 12. Joe. On 24 Oct, 16:02, "Nigel" wrote: You could use an autofilter and choose the top 10, the filtered list can then be copied. Record macro if you need the code to do this. -- Regards, Nigel "Joe Maldon" wrote in message ups.com... 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- Hide quoted text - - Show quoted text - |
All times are GMT +1. The time now is 04:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com