Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Top 10 Ranking again
Thanks to everyyone that helped me before
The problem i have is that i want to be able to extract data from one sheet and put it in another. So far i have managed (with help) to get the top 10 names and scores to appear on another tab but i would like to add one more column which is the year The data is held in names = A3 to A220 Year = B3 to B220 Score = P3 to P220 There is other data inbetween Column B and P so i can't use the conventional sort option The calulation i used to get some of the data so far is =INDEX(Sickhistory!A$3:A$220,MATCH(LARGE(Sickhisto ry!P$3:P$220,ROW(B1)),Sickhistory!P$3:P$220,0) Hope someone can help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Top 10 Ranking | Excel Discussion (Misc queries) | |||
Ranking | Excel Worksheet Functions | |||
Ranking | Excel Worksheet Functions | |||
Ranking | Excel Discussion (Misc queries) | |||
Ranking | Excel Worksheet Functions |