Taking Advantage Of Excel’s GROUPBY Function Not long ago, I wrote about Excel’s PIVOTBY function – a recently published Excel feature that allows you to build formula-based PivotTables in Excel. When Microsoft added PIVOTBY to Excel, they also added another new function, GROUPBY. Read on, and you will discover how to use GROUPBY to summarize information quickly and easily. What Is GROUPBY? Like Excel’s SUM, SUBTOTAL, PIVOTBY, and other functions, GROUPBY is a feature in Excel that you can use to summarize information. However, GROUPBY differs from these other features in that it allows you to quickly and easily aggregate…
