Filter columns to get headers

Regular Contributor



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: 

green list.PNG


Example attached.


Best Regards

- Geir

1 Reply

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.