This Excel challenge uses a Groupby concept to Group by a parameter and subtotal by another.
00:00 Introduction
00:21 Problem Description
00:56 Victor's thoughts on a solution
01:15 A PivotTable solution
05:07 Formula solution using Groupby
07:22 Final cleanups
08:57 Comparing the formula to a Pivot
09:38 Final thoughts and conclusion
Link to Workbook:
docs.google.com/spreadsheets/...
Негізгі бет Excel Challenge: GroupBy and Subtotal
Пікірлер: 24