Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro for top10 and wors10 in ranking
Is there a way do a macro to ...extract the top10 and worst10 people from a
ranking? I have a worksheet with 200+ employees, they all have 5 measures and based on their scores they are assigned points and when points are added, a ranking is made. I have my formulas for the points and ranking done & I can identify the top10 and worst10 in column G using the SMALL and LARGE formulas but ...I need to somehow extract/copy the whole rows for the top10 and worst 10 and paste them into a new sheet?? can that be done? it looks like this but will 200+ rows A B C D E F G 1 Name Score1 Score2 Score3 Score4 Score5 RANK 2 mika 85% 90% 30% 2% 55% 5 3 tetsu 94% 92% 50% 1% 88% 1 4 shouji 95% 33% 26% 7% 44% 9 Cheers, Mayte |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get drop-down list that includes, eg top10 | Excel Worksheet Functions | |||
Ranking | Excel Discussion (Misc queries) | |||
AutoFilter Top10 not working | Excel Discussion (Misc queries) | |||
Ranking | Excel Discussion (Misc queries) | |||
AutoFiltering for Top10 | Excel Programming |