Create Data Validation List from Excel Table (3 Easy Ways)
Автор: TrumpExcel
Загружено: 2025-03-11
Просмотров: 18551
Описание:
Excel doesn't allow you to use structured references with in data validation dialog box, but there are some workarounds.
In this video I'm going to show you three easy workarounds you can use to use Excel table structure references within data validation dialog box
00:00 Intro
01:24 Using INDIRECT Function
02:53 Using NAMED Ranges
04:07 Using range reference itself
Read Article - https://trumpexcel.com/data-validatio...
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-c...
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...
#Excel #ExcelTips #ExcelTutorial #SumitBansal
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
