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
I am trying to understand how to search on multiple pieces of data within a column that has over 180K rows. Columns A - AO and 180,000 rows. Column H I am looking to find for example the following data sets (12345, 67891, 01234, 56789).
How would I search all 4 data sets in that one column at the same time? does tis make sense?
How would I search all 4 data sets in that one column at the same time? does tis make sense?
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
- Thank you very much. That worked. However, I did need to look up that I had to add (*) to my data set for it to work. Appreciate your help and generous time.