Популярное

Музыка Кино и Анимация Автомобили Животные Спорт Путешествия Игры Юмор

Интересные видео

2025 Сериалы Трейлеры Новости Как сделать Видеоуроки Diy своими руками

Топ запросов

смотреть а4 schoolboy runaway турецкий сериал смотреть мультфильмы эдисон
dTub
Скачать

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/

The 2nd EASIEST Excel multiple level drop down list. Newer even easier video is available in link 🔔

Поделиться в:

Доступные форматы для скачивания:

Скачать видео mp4

  • Информация по загрузке:

Скачать аудио mp3

Похожие видео

array(10) { [0]=> object(stdClass)#6196 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "0AF32QMBehE" ["related_video_title"]=> string(54) "Excel self-updating Drop Down List for Data Validation" ["posted_time"]=> string(21) "2 года назад" ["channelName"]=> string(15) "Access Analytic" } [1]=> object(stdClass)#6169 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "8l9Wp0T_SOE" ["related_video_title"]=> string(89) "Multiple Dependent Drop-Down List in Excel | NEW Simple Method | Works with multiple rows" ["posted_time"]=> string(19) "1 год назад" ["channelName"]=> string(30) "Rebekah Oster - Excel Power Up" } [2]=> object(stdClass)#6194 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "lxd4Pc_gMIA" ["related_video_title"]=> string(73) "THE Easiest Multi Level Drop Down List ( easy Double XLOOKUP technique )" ["posted_time"]=> string(27) "7 месяцев назад" ["channelName"]=> string(15) "Access Analytic" } [3]=> object(stdClass)#6201 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "7mo4COng7Sg" ["related_video_title"]=> string(65) "Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)" ["posted_time"]=> string(19) "5 лет назад" ["channelName"]=> string(13) "Leila Gharani" } [4]=> object(stdClass)#6180 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "AtiWRzsdKUw" ["related_video_title"]=> string(87) "How to consolidate multiple Excel files with multiple sheets - Easy and Tricky examples" ["posted_time"]=> string(25) "4 месяца назад" ["channelName"]=> string(15) "Access Analytic" } [5]=> object(stdClass)#6198 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "RXSH2UiDc5g" ["related_video_title"]=> string(49) "NEW Excel Drop-Down Lists That Adapt to Your Data" ["posted_time"]=> string(27) "9 месяцев назад" ["channelName"]=> string(19) "MyOnlineTrainingHub" } [6]=> object(stdClass)#6193 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "P3_k6aJsjFo" ["related_video_title"]=> string(64) "Even easier than easiest - Multi Level Dependent Drop Down Lists" ["posted_time"]=> string(27) "6 месяцев назад" ["channelName"]=> string(18) "Excel Off The Grid" } [7]=> object(stdClass)#6203 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "F92BOYiJF4o" ["related_video_title"]=> string(77) "Creating Multi-Level Dependent Drop Down Lists in Excel - New and Better Way!" ["posted_time"]=> string(27) "6 месяцев назад" ["channelName"]=> string(10) "TrumpExcel" } [8]=> object(stdClass)#6179 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "4Oaveqn2YwY" ["related_video_title"]=> string(125) "Эти 5 СЕКРЕТНЫХ функций в Excel НИКТО не использует. Вот, что они делают!" ["posted_time"]=> string(25) "4 недели назад" ["channelName"]=> string(54) "Эксперт ЭКСЕЛЬ и ГУГЛ-ТАБЛИЦЫ" } [9]=> object(stdClass)#6197 (5) { ["video_id"]=> int(9999999) ["related_video_id"]=> string(11) "m79WuU1OgpI" ["related_video_title"]=> string(70) "You’ve Been Using Excel Drop-Downs Wrong This Whole Time…" ["posted_time"]=> string(23) "1 месяц назад" ["channelName"]=> string(21) "Excel For Freelancers" } }
Excel self-updating Drop Down List for Data Validation

Excel self-updating Drop Down List for Data Validation

Multiple Dependent Drop-Down List in Excel | NEW Simple Method | Works with multiple rows

Multiple Dependent Drop-Down List in Excel | NEW Simple Method | Works with multiple rows

THE Easiest Multi Level Drop Down List ( easy Double XLOOKUP  technique )

THE Easiest Multi Level Drop Down List ( easy Double XLOOKUP technique )

Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)

Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)

How to consolidate multiple Excel files with multiple sheets - Easy and Tricky examples

How to consolidate multiple Excel files with multiple sheets - Easy and Tricky examples

NEW Excel Drop-Down Lists That Adapt to Your Data

NEW Excel Drop-Down Lists That Adapt to Your Data

Even easier than easiest - Multi Level Dependent Drop Down Lists

Even easier than easiest - Multi Level Dependent Drop Down Lists

Creating Multi-Level Dependent Drop Down Lists in Excel - New and Better Way!

Creating Multi-Level Dependent Drop Down Lists in Excel - New and Better Way!

Эти 5 СЕКРЕТНЫХ функций в Excel НИКТО не использует. Вот, что они делают!

Эти 5 СЕКРЕТНЫХ функций в Excel НИКТО не использует. Вот, что они делают!

You’ve Been Using Excel Drop-Downs Wrong This Whole Time…

You’ve Been Using Excel Drop-Downs Wrong This Whole Time…

© 2025 dtub. Все права защищены.



  • Контакты
  • О нас
  • Политика конфиденциальности



Контакты для правообладателей: [email protected]