Forum Discussion
How to have items belong to multiple different categories and then be able to filter.
While I can't follow why you don't use filters and create a table from them beforehand, I'll send you these links with the information that might help you.
You can create and format a table, to visually group and analyze data.
Filter data in a range or table
At the same time, with your permission, I would like to recommend that you include information about your digital environment in advance. Inform about your Excel version, operating system/network, storage medium, etc. .
If possible, attach a file and use this file (Drag and drop here or browse files to attach Maximum size: 71 MB ) to explain your intention step by step, so you can get a possible solution much faster and more accurately... and the helper is not forced to make assumptions.
Hope I was able to help you with this info.
Thank you for your understanding and patience
I know I don't know anything (Socrates)