Includes One of Many Filters

An Excel file that teaches how to perform Includes One of Many Filters operation.

Excel Template for Includes One of Many Filters

In the study, data containing any of more than one criterion was automatically filtered. A flexible filtering structure has been created by using FILTER, ISNUMBER and MATCH functions together. The aim is to list the corresponding rows if the values ​​in a particular column match any values ​​in the predefined list. The readability and maintainability of formulas are increased with the use of Named Range. Thanks to dynamic array functions, automatic updating of the results is made possible. A general solution is presented to be compatible with different data sets and criteria lists.

Hope it is useful.