Connect Power Query to a Dynamic Dropdown List
Can Excel's Power Query (Get and Transform) be used as contents for a dropdown list in Excel? And what would be a good use for it?
That came across my mind recently and this video is the result of that inquiry. You'll see COUNTIFS, Dropdown boxes, Fill-Down, and everything!
Thumbnail Photo by: Marina Green Photography in Vancouver, WA
For an intro to Get & Transform (Power Query) try my Lynda.com course:
https://www.lynda.com/Excel-tutorials...
Website: http://ozdusoleil.com
My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analy...
My old blog: http://datascopic.net/blog-2-2
#ExcelDropDownLists
#COUNTIFS
#ExcelTables