Top 10 Ranking again

L

louiscourtney

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(Sickhistory!P$3:p$220,ROW(B1)),Sickhistory!P$3:p$220,0)

Hope someone can help
 

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

Top