00172 Unique Values for Drop Down List @MySpreadsheetLab
00172 Unique Values for Drop Down List  @MySpreadsheetLab
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
00172 Unique Values for Drop Down List00179 Data Disaster non normalized dataVideo 00029 OFFSET function with combo box00155 Analyze Super Sloppy DatasetVideo 00081 Count and find different types of Excel errors00157 Array or Aggregate to solve Excel puzzle? EMT1377Video 00116 Formula Reminds You To Refresh PivotVideo 00133 Partial Sequential MatchVideo 00002 SUMPRODUCT_function Part1Video 00026 Financial Functions_FUTURE VALUE part 2Video 00140 Get Address for Largest Value00170 Bill Szyszs Solution to Debs Challenge
Kevin Lehrbass |

00172 Unique Values for Drop Down List

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER