Forum Discussion
Filtering for multiple items
Hello!
I have a set of data in which I need to filter for 97 items. How do I filter a different data set for 97 items so that I don't have to filter it 97 times?
Thanks!
An alternative could be Power Query. In the attached file you can add data to the large blue dynamic table and filter criteria to the small blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table. The green table returns all rows where column "Heading1" of the large blue table has an exact match with an entry of the small blue table.
The data layout in the screenshot and in the attached file is for illustration. You can place the green result table in another worksheet as well.
It depends on if you'd like to filter-in-place or filter with formula.
A few options:
Filter with FILTER function:
=FILTER(Demo,ISNUMBER(XMATCH(Demo[Team],crit)))A filter-in-place option: Custom Views (The workbook must not have any tables)
Create, apply, or delete a custom view - Microsoft Support
