Nov 20 2022 12:32 PM - edited Nov 20 2022 12:33 PM
Hi, please can someone help me with dynamic dropdowns? I have the latest version of Excel so can use UNIQUE and FILTER formulas if required.
Dropdown level 1 | Dropdown level 2 | Dropdown level 3 |
Group 1a | Fruit 1 | Vegetable 1 |
Group 1a | Fruit 2 | |
Group 1a | Fruit 3 | Vegetable 2 |
Group 1a | Fruit 3 | Vegetable 3 |
Group 1b | Box A | Letter 1 |
Group 1b | Box B | |
Group 1c | Example 1 | |
Group 1c | Example 2 | |
Group 1c | ||
Group 1c | ||
Group 1d | Example 5 | |
Group 1d | Example 6 |
Column 1 | Column 2 | Column 3 |
Group 1c | ||
Group 1d | Example 6 | |
Group 1a | Fruit 1 | Vegetable 1 |
Group 1a | Fruit 2 | |
Group 1c | Example 2 |
Many thanks in advance!
Nov 20 2022 03:22 PM
See if what I've created in the "Three Levels" tab of this workbook meets your need. I know you can add rows to the basic table in the top left region, and the resulting values will all populate the corresponding dynamic drop-down lists. Mine is abstraction in the extreme, to illustrate the concept. I may take it (created in response to your question) and go apply it to my budget spreadsheet, where I took a different approach. But I'll be interested in whether this is what you are looking for.