Dec 16 2021 03:46 AM
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
Dec 17 2021 12:16 AM
Solution
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.
Dec 17 2021 12:16 AM
Solution
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.