Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Easy Dynamic Dependent Data Validation Two Ways. That video is uploaded by MyOnlineTrainingHub at 2021-08-26T05:00:18-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [pjLAnpBM9dk]
| Name | Easy Dynamic Dependent Data Validation Two Ways |
| Video Uploader | Video From MyOnlineTrainingHub |
| Upload Date | This Video Uploaded At 26-08-2021 12:00:18 |
| Video Discription | Dynamic Dependent Data Validation lists are easy with dynamic array formulas, but in this video I show you both with and without dynamic arrays. Download the Excel file here: https://www.myonlinetraininghub.com/dynamic-dependent-data-validation To dynamically expand the regions for more countries, copy the FILTER function across more columns and use the 'not found' argument in FILTER to return blank with two double quotes, e.g.: =SORT(FILTER(TblRegions[Region],TblRegions[Country]=H4,"")) Then modify the XLOOKUP to also include further columns e.g. if your FILTER formulas are in columns H:P your XLOOKUP would be: =XLOOKUP($B5,$H$4:$P$4,$H$5:$P$5)# 0:26 Dependent Data Validation without dynamic arrays 1:28 Setting up Data Validation Lists 1:55 Setting up depeneden Data Validation Lists with INDIRECT 3:12 Dependent Data Validation with dynamic arrays 3:25 Distinct List for Primary Data Validaton List 3:56 Secondary Lists for dependent Data Validation Lists 5:20 Setting up depeneden Data Validation Lists with XLOOKUP View my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ pjLAnpBM9dk |
| Category | Science & Technology |
| Tags | excel data validation | dependent data validation | drop down lists | dependent drop down lists |
