Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
110
Views
Topic starter
Hi there. Has anybody come up with a neat way to take data from a table and place it in a matrix please? example of what I am looking for is attached
Posted : 12/06/2020 6:17 am
Hi Allyn,
You could force a Treemap to do something resembling what you want, but it's temperamental and not really designed for this.
The other approach is to use the FILTER function - if you have dynamic arrays.
Please see attached.
regards
Phil
Posted : 12/06/2020 8:11 am
