Тёмный

Excel - Create Dynamic and Dependant Drop Down Lists 

Jason Lucas - Excel Formulas
Подписаться 133
Просмотров 979
50% 1

A lesson on how to create dynamic and dependant drop down lists is Microsoft Excel. Join me on this data validation tutorial. I also go over the INDIRECT function as well as how to create a table.
00:01 Intro
00:19 Indirect Function
01:39 Create Table
02:24 Dynamic Drop Down List
03:35 Dependant Drop Down List
06:02 Thanks For Watching
Like and Subscribe!
/ @jasonlucasexcel
#dropdownlist #exceltutorial #datavalidation

Опубликовано:

 

16 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 3   
@asaf996
@asaf996 2 месяца назад
Great tips! Thanks Could you make a vid explaining how can I choose a state from a dropdown and it will automatically give me the matching city?
@JasonLucasExcel
@JasonLucasExcel 2 месяца назад
I recommend using the FILTER function. Let's say the table is called City and has 2 columns, Column A City and Column B State and the dropdown list appears in cell D1. In D2 type =FILTER(City[City],City[State]=D1) Thanks for the question and feedback, I will work that in a future video.
@sass1330
@sass1330 2 месяца назад
What if I want to choose a project from the drop down list and then automatically get its progress? ​@@JasonLucasExcel
Далее
Excel - Create Team Calendar
13:18
Просмотров 959
Это было очень близко...
00:10
Просмотров 3,1 млн
Million jamoasi - Amerikaga sayohat
12:37
Просмотров 466 тыс.
Excel - XLOOKUP
4:18
Просмотров 107