NEW Excel Drop-Down Lists That Adapt to Your Data скачать в хорошем качестве

NEW Excel Drop-Down Lists That Adapt to Your Data

Create self-updating dependent drop-down lists with dynamic array formulas. 👩‍🏫 Learn Excel with my courses: https://bit.ly/ddlists24courses ⬇️ Download the example file here and follow along: https://bit.ly/ddlists24file Dependent drop-down lists where you choose a country and magically the next drop-down list only displays the states for that country used to be laborious to set up and maintain, but now that we have dynamic array formulas, we can make them dynamic, so they automatically grow with your data. In this video, I’m going to show you two approaches, one that’s relatively straight forward but has some limitations, and one that overcomes those limitations using a trick that is mind blowing. CORRECTION: I learned this technique from Ceasr of the @Excelambda channel. Check out his work. LEARN MORE =========== 📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/e... 🎯 FOLLOW me on LinkedIn:   / myndatreacy   💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/e... ⏲ TIMESTAMPS ============== 0:00 Method №1 5:14 Method №2 #Excel #ExcelTricks #ExcelDataValidation