Filter columns to get headers

Regular Contributor

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: 

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.

DTE_0-1639728955783.png