Forum Discussion
Solved
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 m...
- 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
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.