| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Retrieve multiple data rows data from a very long list and copy t
I need to retrieve multiple data rows data from a very long list and copy
them to another worksheet. The list has over 1000 rows. The rows all have the unique data but are all have an ID number corresponding to one person, we have 37. The ID number is in the left most column. Vlookup will find the first row only. Countif finds the total number of records but how would I find then copy all the rows of data that corresponds to person number 7? Any help would be appreciated! Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Retrieve multiple data rows data from a very long list and copy t
Have you tried Autofilter or advanced filter?
"Mathew" wrote: I need to retrieve multiple data rows data from a very long list and copy them to another worksheet. The list has over 1000 rows. The rows all have the unique data but are all have an ID number corresponding to one person, we have 37. The ID number is in the left most column. Vlookup will find the first row only. Countif finds the total number of records but how would I find then copy all the rows of data that corresponds to person number 7? Any help would be appreciated! Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| how do I insert 4 rows in between each value in a list of data | Excel Discussion (Misc queries) | |||
| Copy Data List | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Lookup values in a list and return multiple rows of data | Excel Worksheet Functions | |||
Hybrid Mode
