Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extracting data from large worksheet | Excel Worksheet Functions | |||
Ignoring Rows When Extracting Data From One Worksheet To Another | Excel Worksheet Functions | |||
Extracting data from one Worsheet to Another Worksheet with common link value | Excel Discussion (Misc queries) | |||
Extracting data from a client worksheet to create an invoice | Excel Discussion (Misc queries) | |||
Extracting worksheet names.... | Excel Worksheet Functions |