Extract mutliple rows from a dataset

%3CLINGO-SUB%20id%3D%22lingo-sub-2423411%22%20slang%3D%22en-US%22%3EExtract%20mutliple%20rows%20from%20a%20dataset%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2423411%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%20I%20have%20a%20large%20data%20set%20with%203%2C044%20rows%20and%20several%20across.%26nbsp%3B%20I%20want%20to%20locate%20and%20pull%20out%20a%20specific%20108%20of%20them.%26nbsp%3B%20The%20only%20way%20I%20know%20how%20to%20do%20it%20is%20through%20the%20filter%20option%20and%20that%20takes%20a%20long%20time.%26nbsp%3B%20I%20have%20done%20it%20twice%20and%20already%20have%20a%20sheet%20with%20the%20specific%20items%20that%20I%20want%20but%20I%20need%20to%20do%20it%20again.%26nbsp%3B%20Basically%2C%20this%20is%20a%20longitudinal%20study%20of%203%2C044%20individuals%20with%20several%20datasets%20on%20different%20spreadsheets%20and%20I%20want%20to%20extract%20the%20same%20108%20on%20each%20spreadsheet%2C%20but%20need%20an%20easier%20way%20than%20filtering%20it%20each%20time.%26nbsp%3B%20Is%20there%20a%20way%20to%20tell%20Excel%2C%20%22hey%2C%20I%20want%20these%20108%20individuals%20from%20this%20spreadsheet%2C%20can%20you%20pull%20those%20individuals%20and%20their%20entire%20row%20for%20me%3F%22%20This%20is%20for%20my%20dissertation%20and%20i%22m%20not%20overly%20Excel%20savvy.%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2423411%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2423470%22%20slang%3D%22en-US%22%3ERe%3A%20Extract%20mutliple%20rows%20from%20a%20dataset%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2423470%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1073137%22%20target%3D%22_blank%22%3E%40SadGradStudent%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20have%20the%20most%20recent%20version%20of%20Excel%2C%20there%20is%20a%20FILTER%20function%20now%2C%20and%20you%20can%20use%20it%20to%20extract%20any%20number%20of%20rows%20that%20meet%20criteria%20you%20specify.%20Short%20of%20seeing%20your%20actual%20spreadsheet%2C%20I%20can't%20give%20you%20much%20more.%20Here%2C%20though%2C%20is%20a%20link%20to%20a%20YouTube%20video%20that%20serves%20as%20a%20wonderful%20intro%20and%20demo.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi all, I have a large data set with 3,044 rows and several across.  I want to locate and pull out a specific 108 of them.  The only way I know how to do it is through the filter option and that takes a long time.  I have done it twice and already have a sheet with the specific items that I want but I need to do it again.  Basically, this is a longitudinal study of 3,044 individuals with several datasets on different spreadsheets and I want to extract the same 108 on each spreadsheet, but need an easier way than filtering it each time.  Is there a way to tell Excel, "hey, I want these 108 individuals from this spreadsheet, can you pull those individuals and their entire row for me?" This is for my dissertation and i"m not overly Excel savvy. Thank you!

1 Reply

@SadGradStudent 

 

If you have the most recent version of Excel, there is a FILTER function now, and you can use it to extract any number of rows that meet criteria you specify. Short of seeing your actual spreadsheet, I can't give you much more. Here, though, is a link to a YouTube video that serves as a wonderful intro and demo.

 

https://www.youtube.com/watch?v=9I9DtFOVPIg

 

Learn everything about our brand-new Dynamic Arrays and how you can use them to build advanced spreadsheets. Arrays (CSE) have long been present in Excel, bu...