View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
louiscourtney louiscourtney is offline
external usenet poster
 
Posts: 40
Default 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