Filter columns to get headers

[Geir Hogstad]

Hi.

How do I filter the headers if several rows meet the condition? I Want the headers (vendors) if the value is greater than 1. (product selected). The green list here: 

Example attached.

Best Regards

- Geir

[#2 · Accepted solution]

Hi @Geir Hogstad 

there is a solution for this if you use Microsoft 365: the FILTER function. In the attached file you can see it in the area below your matrix.