I need to have a filter with 50+ “Or”/“Contains” conditions for easy/quick cleaning of data.
It should display all records that meet one or more of the conditions (e.g., Field Name “Company” Contains “Accounting”) and then I can quickly delete any/all records that meet those conditions to cleanup the list of records.
Is there a way to add many more conditions to a standard filter criteria beyond the 8 that appear in the Filter Criteria box?
Is there also a way to save that filter so it can be used across multiple sheets as needed?
Thank you,
Duane