Forum Discussion
Need help on how to do advanced filtering in Excel '13
I have a spreadsheet with 180,000 rows and want to filter subsets of the data in one column. The filter only allows me to enter one piece of data. Too many rows to try to use the select each data method.
- I think this video will help you. I'd watch the whole thing, but I think what you want is at the 4:30 mark. https://www.youtube.com/watch?v=2ArPmAqxY7E&list=PLtjZ7yboDT5aDAqMVbTAVIusDqKi05xx8&index=43
7 Replies
Take a look at the attached file. There are 60000 rows in columns A to D that are filtered if values of range E2:E104 are found in column D. The criteria range for advanced filter is in range G3:G4. The filter result is in columns I to L. In cells O4 and P4 i entered nested sum formulas to verify the result of the advanced filter.
Is this what you want to do?
OliverScheurich Thank you kindly for taking the time to respond and offering your help. Unfortunately, I don't understand what you said or what I am supposed to look for in the spreadsheet. I have a very large spreadsheet sheet with thousands of rows. I need to filter a subset of data in one column. Using the filter option only allows me to filter on 1 piece of data not multiple pieces of data in that column.
I attached an example of 4 columns and 60000 rows each. Search /filter values are in range E2:E5. The filter result is in columns I to L. All rows that have one of the search / filter values in column D (header is "Column4") are selected and displayed in columns I to L. This could be what you want to do.
