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
$220,ROW(B1)),Sickhistory!P$3$220,0)
Hope someone can help
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
$220,ROW(B1)),Sickhistory!P$3$220,0)Hope someone can help