Forum Discussion
Sub labels
I have attached an example with all confidential data removed. Thank you.
Not quite: you forgot the other sheets in the workbook. You should take this sample down immediately. If you don't, a forum administrator will, but whatever, it should be done quickly.
Since I've already looked at it, I do have some questions. A lot of the examples you give of sub-categories are identical to the category next to them...
Do you have the most current release of Excel? If so, I'm wondering if you could use the new functions FILTER and SORT, which operate as Dynamic Array functions. Here's a video that I used to learn about them. It's what I'd try if I were in your shoes.
It might be necessary to fill in all of the columns; you've made the mistake (if you'll forgive me for saying it that way) of making your sheet look aesthetically pleasing--it's quite nice--before developing the functionality you seek. That generally is a mistake. The INPUT or raw data end of things isn't necessarily where looks should matter; save that for the output end, after you've FILTERed and SORTed. And Input and Output often work better as separate sheets. Watch the video.
https://www.youtube.com/watch?v=9I9DtFOVPIg
