Hey guys,
I have to make a Dependent Dropdown list for a small encoding task at work, however, the tutorials I find online aren't suited for the format we use in our database.
Here's an example & picture of what I mean:
The tutorials point towards having named ranges on top of the table, then using that in an indirect formula, and having the secondary dropdown validation rely on this (see example A). I can't do this simply because our database numbers in the thousands, and its in a pivot table format. I also tried adapting the tutorials formula to my format, but it won't work.
I need to create a dependent dropdown list that works with pivot table's transacional format. (see example B)
EXAMPLE PHOTO HERE:
unnamed.png
I would greatly appreciate it if someone showed me how to do this.
Bookmarks