Тёмный

Searchable Dropdown List - 2 Examples 

Doug H
Подписаться 79 тыс.
Просмотров 959
50% 1

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

 

8 сен 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 6   
@jerrydellasala7643
@jerrydellasala7643 2 года назад
Nice simple video on this awesome update to Drop Down lists! Worth noting is that if "Allow editing directly in cells" is disabled (unchecked) under Options -> Advanced Options, the drop down list will appear in the FORMULA BAR instead of directly below the cell with the Data Validation list. Also, the Helper array can wrap the search array in SORT(UNIQUE()) to sort the list and avoid duplicate items, and make it easier to confirm matches.
@DougHExcel
@DougHExcel 2 года назад
Hi Jerry Dellasala, thanks for the comment and adding knowledge to the thread!!
@miaquaintrelle
@miaquaintrelle 2 года назад
Brilliant as usual 😀 thanks!
@DougHExcel
@DougHExcel 2 года назад
Thanks!!
@krishnamanjunatha6183
@krishnamanjunatha6183 2 года назад
how to search for particular word or number in a sentence that is whole number or word shud match. plz help😊
@DougHExcel
@DougHExcel 2 года назад
maybe one of these in the playlist would help ru-vid.com/group/PL-n8f1cY_Qw812xmrApALUPcDzeWf_UYi
Далее
Create Dynamic Dropdown Lists in Excel
13:03
Просмотров 118 тыс.
Fake watermelon by Secret Vlog
00:16
Просмотров 10 млн
Common Pivot Table Features People Miss (and you?)
12:45
EASILY Make an Automated Data Entry Form in Excel
14:52
Pivot Table Design Tricks
28:04
Просмотров 12 тыс.
Try This Instead of the XLOOKUP
10:06
Просмотров 55 тыс.
Make a Search Bar in Excel to Find Anything!
10:35
Просмотров 359 тыс.
Fake watermelon by Secret Vlog
00:16
Просмотров 10 млн