NEW Excel Drop-Down Lists That Adapt to Your Data @MyOnlineTrainingHub
NEW Excel Drop-Down Lists That Adapt to Your Data  @MyOnlineTrainingHub
Uploaded August 2024 | Updated November 2026, 2 days ago
Create self-updating dependent drop-down lists with dynamic array formulas.
👩‍🏫 Learn Excel with my courses: bit.ly/ddlists24courses

⬇️ Download the example file here and follow along: 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: myonlinetraininghub.com/excel-newsletter-sign-up

🎯 FOLLOW me on LinkedIn: linkedin.com/in/myndatreacy

💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum

⏲ TIMESTAMPS
==============
0:00 Method №1
5:14 Method №2

#Excel #ExcelTricks #ExcelDataValidation
NEW Excel Drop-Down Lists That Adapt to Your Data7 Advanced PivotTable Techniques That Feel Like CheatingThe Excel Feature That Replaces 5 Follow-Up Emails (and a Meeting)I Got Hacked in an Unusual Way | Tips to Protect YourselfExcel Shortcuts that Will Save You Hours of Work (Windows & Mac)How to Instantly Improve Your Excel Charts [Watch This!]Most Excel Users Don’t Know You Can Do This Inside a FormulaExcel’s Secret Number Generator | SEQUENCE FunctionChatGPT For Excel: Tips & Tricks to 10X Your ProductivityTEXTJOIN Function Explained in 45 Seconds | Excel TutorialSIMPLE Excel Automations I Use EVERY DAY (and you should too!)The Excel Feature Everyone Loves...But Shouldnt Use (Alternative)
MyOnlineTrainingHub |

NEW Excel Drop-Down Lists That Adapt to Your Data

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER