Dynamic Dependent Data Validation list in Excel MADE SIMPLE | All versions + Excel 365 Solution
In this video, we create dependent data validation list in excel. We create two solutions, one suitable for any version in Excel and the other suitable for Excel 365. We also create a conditional formatting that allows us to check if the selection on the second level of data validation conforms with the current value on the first level of data validation.
Download Example Files to follow along:
https://tinyurl.com/4zatd89b
Thanks to Mynda Treacy for the inspiration on the Excel 365 solution
Mynda Treacy's video:
• Easy Dynamic Dependent Data Validatio...
Related videos to watch:
INDIRECT function: • The indirect function in excel | MULT...
COUNTIF function: • Excel SUMIF SUMIFS COUNTIF COUNTIFS -...
OFFSET function: • Excel OFFSET function basics + Dynami...
XLOOKUP function: • XLOOKUP Function - Lookups made a lot...
Sign up for our Newsletter:
https://tinyurl.com/mr33kcsd
Follow us on Social Media:
Facebook: https://tinyurl.com/254eut6z
Twitter: https://tinyurl.com/ycxkjzkk
LinkedIn: https://tinyurl.com/ycym2nee
Instagram: https://tinyurl.com/3mdpbdwa
TikTok: https://tinyurl.com/p36wae4k
Telegram: https://tinyurl.com/escuvwj9
Website: https://tinyurl.com/twtnwuv9
****My online Excel Courses****
https://www.excelbonanza.com/courses/
#datavalidation #exceltable #filterfunction
