Forum Discussion
Dependent Drop-down List- Formula for only showing cells with data rather than blanks
Hello, I am creating a template that contains multiple, dependent drop-down lists. If you choose a certain thing in the first list, it will only show options related to that choice in the second...
Please refer to my reply here for an idea of a dynamic dependent drop-down list:
https://techcommunity.microsoft.com/t5/Excel/Data-validation-lists-flow-chart/m-p/352133#M25722
https://techcommunity.microsoft.com/t5/Excel/Data-validation-lists-flow-chart/m-p/352133#M25722
Hello Lindsay,
Hereto attached is the file with the dynamic dependent drop-down list you need. Aside from your given data, I added Beverages as a category, along with the corresponding subcategories and items, to the Data sheet.
Being dynamic, you can add (or delete) categories, subcategories, and items in the Data sheet without any required modification in the formula. Download it and inform me of your thoughts about it.
Cheers,
Twifoo
Hello,
I'm still having trouble getting it to work with how my data is set up. I tried removing the tables so the backup data was just text, but the formula still isn't working.
- You just have to rename the Data sheet and the workbook name in me uploaded file. The layout of your data and drop-down list must be strictly in accordance with mine so that the formulas will deliver the expected results.
Thank you!
I have also been looking for this solution for a long time.
I have the following questions:
- How do I add more categories?
- How do I change your input message?
Regards
Johnny
