Hi,

For each row in a dynamic range, I want to filter/select the headers if it is a “X” in the line column.

I made it work with Filter. But I dont get that to be dymamic for each row in the list. 

=TAKE(FILTER($T$8:$AD$10;’Ark1′!T23:AD23=”x”;””);1)

Filter might not be right function here. Any better solutions? 

Best regards

Geir

​Hi, For each row in a dynamic range, I want to filter/select the headers if it is a “X” in the line column. I made it work with Filter. But I dont get that to be dymamic for each row in the list. =TAKE(FILTER($T$8:$AD$10;’Ark1′!T23:AD23=”x”;””);1) Filter might not be right function here. Any better solutions?  Best regardsGeir     Read More

​