Uploaded January 2018 | Updated September 2026, 3 hours ago

---

myspreadsheetlab.com/video-00172-unique-values-for-data-validation-drop-down
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: youtu.be/7fYlWeMQ6L8