00172 Unique Values for Drop Down List
https://www.myspreadsheetlab.com/vide...
00:00 Requirement: drop down list with unique values
01:01 light/simple/dynamic: pick 2
-------------SOLUTIONS---------------------
01:33 Mr Excel: Pivot Table
02:41 Oz du Soleil: Power Query
04:18 Mike Girvin: array formula
05:30 Leila Gharani: formula
06:17 Kevin Lehrbass: helper formulas
09:25 Mike Rempel: auto-complete, pick from drop down
Link to Leila's video: • Extract UNIQUE Items for Dynamic Data Vali...