Dec 17 2021 04:42 PM
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.
Dec 17 2021 06:26 PM
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?
Dec 23 2021 12:42 PM
@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.
Dec 23 2021 02:29 PM
Dec 26 2021 06:51 PM
Dec 27 2021 04:13 AM
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.
Dec 27 2021 08:18 AM
SolutionDec 27 2021 10:59 AM
Dec 27 2021 08:18 AM
Solution