L
louiscourtney
Let me try to explain
In work sheet called Sickhistory
I have columns A to P
In A3 down to A502 i have names
In B3 down to B502 i have Years
Then in columns C to O are columns that are recording data linked from other
sheets
In P3 down to P502 there are various different scores
What i want to be able to do is extract the top 10 scores data from Column P
including the name and years from columns A & B and then add them to a sheet
called Top 10 so that it is displayed something like this
Name Year score
I cannot use the filter button on worksheet Sickhistory as there are cells
of various sizes so it won't filter all the correct information
Any help with this would be extremely appreciated
In work sheet called Sickhistory
I have columns A to P
In A3 down to A502 i have names
In B3 down to B502 i have Years
Then in columns C to O are columns that are recording data linked from other
sheets
In P3 down to P502 there are various different scores
What i want to be able to do is extract the top 10 scores data from Column P
including the name and years from columns A & B and then add them to a sheet
called Top 10 so that it is displayed something like this
Name Year score
I cannot use the filter button on worksheet Sickhistory as there are cells
of various sizes so it won't filter all the correct information
Any help with this would be extremely appreciated