Excel Magic Trick 1159

Extract Unique List For Data Validation List with Power Query

DESCRIPTION

See how to use Power Query to Extract Unique List For Dynamic Data Validation Dropdown:
(00:08) Problem Set, including showing how complicated Array Formula Solution is.
(01:16) Power Query to Extract Column, Remove Duplicates and Remove Empty Cells. (requires Refresh)
(02:39) Create Data Validation Dropdown List from a Power Query Table on the same sheet as the dropdown list. (requires Refresh, Keyboard = Ctrl + Alt + F5)
(03:10) Create Data Validation Dropdown List from a Power Query Table on a different sheet than the dropdown list. (requires Refresh, Keyboard = Ctrl + Alt + F5)




Be the first to comment

Leave a Reply