Hi guys, Welcome to the Advanced Video Search Engine, and you are watching 00172 Unique Values for Drop Down List. That video is uploaded by Kevin Lehrbass at 2018-01-17T10:34:43-08:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [BFojgCsKNjw]
| Name | 00172 Unique Values for Drop Down List |
| Video Uploader | Video From Kevin Lehrbass |
| Upload Date | This Video Uploaded At 17-01-2018 18:34:43 |
| Video Discription | https://www.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: https://youtu.be/7fYlWeMQ6L8 BFojgCsKNjw |
| Category | Education |
| Tags | Excel | data validation | Dynamic |
