Filter a list, if the value is in an array.

[Geir Hogstad]

Hi,

I need to filter a liste if the values in that list is in an array. 

This work, but I can not use it, because the array (B2:G32) is dynamic and generated with a formula.

=FILTER(Tabell1[Projects];COUNTIFS(B2:G32;Tabell1[Projects])>0)

But the end result should be the same as the example.

Best regards

- Geir

[#2]

In your example the array B2:G32 is not dynamic but assuming it is generated by a formula in B2 then you can simply reference B2# and the "#" tells excel to use the entire 'spill range'

[#3 · Accepted solution]

@mtarler 

I Had the same problem using a dynamic area. But solved it.

Concateated the text in the Search array to one string. Did a search for the text in the table in that string, and it worked. Both with an fiexed array, and an dynamic Array using B2#.

- Geir