Скачать с ютуб Dependent Drop Down List in Excel Tutorial в хорошем качестве

Dependent Drop Down List in Excel Tutorial

🔥 Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com In this step-by-step tutorial, first we learn how to create a basic dropdown list in Microsoft Excel. Next, we look at how to create multiple dependent drop-down lists. With multiple dependent drop-down lists, the second or the subsequent drop-down list adjusts based on the selection in the first drop down list. This is helpful to validate data entry. Few quick notes: ✅ This requires the =xlookup function, which is available as part of Microsoft 365. Unfortunately, older versions of Excel don't currently support this. ✅ To use this on multiple rows, use =transpose as part of the formula: =TRANSPOSE(SORT(UNIQUE(XLOOKUP(A8,Table1[#Headers],Table1),,TRUE))) Then you'll just need to copy the formula down for however many rows you have. You can even place the filtered list on a separate sheet or just hide those columns. ✅ You can access the sample sheet here: https://1drv.ms/x/s!AmxrofZZlZ-whMc5Q... 👋 Additional resources - Sample file to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whMc5Q... - How to Create a simple Excel Drop Down list:    • Excel Drop Down List Tutorial   - In-depth tutorial on Excel look up functions:    • VLOOKUP in Excel | Tutorial for Begin...   - Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com ⌚ Timestamps 0:00 Introduction 0:42 Create simple drop-down list 2:50 Create dependent drop-down list 3:43 Use XLOOKUP function 6:17 Create drop-down list with XLOOKUP output 7:07 Use UNIQUE function 9:20 Use SORT function 10:44 Wrap up 📃 Watch related playlists - Playlist with all my videos on Excel:    • ❎ How to use Excel   🚩 Connect with me on social - LinkedIn:   / kevinstratvert   - Twitter:   / kevstrat   - Facebook:   / kevin-stratvert-101912218227818   - TikTok:   / kevinstratvert   🔔 Subscribe to my YouTube channel https://www.youtube.com/user/kevlers?... 🎬 Want to watch again? Navigate back to my YouTube channel quickly http://www.kevinstratvert.com 🛍 Support me with your Amazon purchases: https://amzn.to/3kCP2yz ⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same. #stratvert