Learn how you can create DYNAMIC DEPENDENT data validation lists in Excel. you only need one formula .
just notice if your data for the First drop down have spaces in it you should replace function that used for the second drop down with this Formula : =INDIRECT(SUBSTITUTE($B$7," ","_"))
and when you rename the table use underline "-" instead of spaces in the Table name
Link to more YouTube Shorts videos:
Excel - Magic Tricks: [ Ссылка ]
Excel - Advanced Sorting: [ Ссылка ]
Excel - Conditional Formatting: [ Ссылка ]
Excel - Functions: [ Ссылка ]
Excel-Lookup: [ Ссылка ]
Excel - Dashboard and Visualization: [ Ссылка ]
Excel-Charts: [ Ссылка ]-
Excel - Shortcut: [ Ссылка ]
Excel-Date And Time: [ Ссылка ]
Excel - Dynamic Array Functions: [ Ссылка ]
Excel - Formatting: [ Ссылка ]
Excel - Data validation: [ Ссылка ]
Excel - Text Functions: [ Ссылка ]
Excel - PivotTable: [ Ссылка ]
Excel - VBA: [ Ссылка ]
Excel - Power Query: [ Ссылка ]
#excel
#exceltipsandtricks
#exceltutorial
#exceltips
#short
#shorts
#shortvideo
#microsoftexcel
#excelshorts
#advancedexcel
#exceltipsandtricks
#exceltutorial
#exceltutorials
#excelshortvideo
#excelshortcuts
#excelshortcutkeys
#excelshortcut
#excel
#advancedexcel
#excelshortcuts
#excelshortcut
#excelshortcutkeys
#excelshortcutkeys
#exceltricks
#exceltraining
#exceltricksandtips
#exceltipsandtricks
#excelfunctions
#excelfunction
#excelformula
#excelformulasandfunctions
#excelformulas
#dropdown
#dropdownlist
#dropdownmenu
Song: Luke Bergs & MBB - Poolside
Music provided by Vlog No Copyright Music.
Video Link: [ Ссылка ]
![](https://i.ytimg.com/vi/8jVqQjKnmFg/mqdefault.jpg)