Hi,
I have a table (example attached) with row and column heading values. Some of the cells in the table have a value ("y").
When I select a value of Column A (Permissions in example) I would like all of the headings to list underneath each other that contain the value of "y".
Hopefully the example sheet makes it clearer what I'm after.
Thanks
UPDATE: nevermind, I worked it myself, thanks anyway!!
Bookmarks