Download Excel Start File: [ Ссылка ]

[ Ссылка ]

Download File: [ Ссылка ]
See how to use Power Query to Extract Unique List For Dynamic Data Validation Dropdown:
1. (00:08 minute mark) Problem Set, including showing how complicated Array Formula Solution is.
2. (01:16 minute mark) Power Query to Extract Column, Remove Duplicates and Remove Empty Cells. (requires Refresh)
3. (02:39 minute mark) Create Data Validation Dropdown List from a Power Query Table on the same sheet as the dropdown list. (requires Refresh, Keyboard = Ctrl + Alt + F5)
4. ( minute mark) Create Data Validation Dropdown List from a Power Query Table on a different sheet than the dropdown list. (requires Refresh, Keyboard = Ctrl + Alt + F5)

Related Video:
Excel Magic Trick 1023: Extract Unique List of Names For Dynamic Data Validation Dropdown List
[ Ссылка ]

Miguel Escobar and Ken Puls are doing online workshops on Power Query www.powerquery.training . This training is not by excelisfun.

свернуть