Forum Discussion
Extract mutliple rows from a dataset
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 take...
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