The 2nd EASIEST Excel multiple level drop down list. Newer even easier video is available in link 🔔
Автор: Access Analytic
Загружено: 2023-05-20
Просмотров: 95877
🔔update: if you have a version of Excel 365 updated after July 2024 then here’s an even easier approach
EVEN EASIER! Dependent Drop Down Technique in UNDER 9 minutes!
• THE Easiest Multi Level Drop Down List ( e...
————————
For those of you with older versions of Excel i also have an update to the method in this video:
Easiest Multi Level Excel Drop Down List
A more robust solution here
• Updated 2nd Easiest Multi Level Excel Drop...
One-Off dependent drop down lists in data validation are relatively straightforward: here's a technique using XLOOKUP. • Easy Dependent Drop Down List with XLOOKUP
!!BUT!! if you want row after row of dependent lists it needs a different approach.
I've seen a lot of solutions out there that attempt to solve this, I've even done a crazy one a few months back, but this is by far the easiest technique I've come across.
⚠️ To prevent any value being typed in the dependent validation boxes you MUST UNTICK "Ignore Blanks". This in my view is a bug and will hopefully be fixed one day.
00:00 Intro
01:06 The Setup
01:50 Formula 1
=UNIQUE(tblOptions[List1])
02:53 Formula 2
=TOROW(
UNIQUE(
FILTER( tblOptions[List2], tblOptions[List1]=G6, "Empty List")))
04:50 Formula 3
=XLOOKUP(AB5, Level1Choice, Level2Result )#excel
06:14 Apply formulas to Data Validation
08:04 The Second Level List
10:36 Conditional Formatting
=COUNTIFS( XLOOKUP( I7, Level2Choice, Level3Result )#, J7)=0
You can download my workbook from the bottom of my blog post here:
https://accessanalytic.com.au/easiest...
----------------------------------
Thanks to Celia Alves for the inspiration. Check out Celia's video here:
• Dynamic Dependent Dropdown Lists in Excel:...
----------------------------------
Thanks to Erik Oehm for trying to inspire me with Lambdas ( I'll get there one day! 😁 )
Here's Erik's elegant Lambda based solution (m
https://aasolutions.sharepoint.com/:f...
Check out his new YouTube channel / @excelrobot
----------------------------------
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
Connect with me
https://wyn.bio.link/

Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: