1a) What is the best way in excel to auto/advanced filter a column of data for a huge list of values, to meet the "does not contain" criteria. Auto filter only seems to to give you 2 fields to enter values using its and/or options in auto filter. But I need to filter a sheet on a specific column of 100,000 records for all records that 'do not contain' approximately 100 values in a specific column.
1b) If the 'does not contain' values contains multiple words, e.g. "does not contain", do you need the list of values in quotation marks?
2) Secondly, is there any way to apply a filter to a list using 'does not contain' type logic, but exempt certain records from the filter which are on an exempt list (e.g. 'keep them in place' and don't filter them out.. such as records that do actually contain the keyword that you would be using in the 'does not contain' query. Is this at all practical with the features available somewhere on the data tab?
I've been testing some of the various options in auto/advanced filter and I think I may be pushing the features to far with what I need to accomplish so hopefully there are alternatives that I am not aware of.