00157 Array or Aggregate to solve Excel puzzle? EMT1377 @MySpreadsheetLab
00157 Array or Aggregate to solve Excel puzzle? EMT1377 @MySpreadsheetLab
Uploaded February 2017 | Updated September 2026, 52 minutes ago
Normally I would use an array but I watched Mike Girvin's EMT1377 and now I can solve this puzzle with Excel's Aggregate function!
00157 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 ChallengeVideo 00129 Tax Lookup_Alternative SolutionsVideo 00016 VLOOKUP introductionVideo 00088 Proper Design = easy formula00147 Conditionally Add Checkboxes using VBAVideo 00128 Tax Lookup
Kevin Lehrbass |

00157 Array or Aggregate to solve Excel puzzle? EMT1377

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER