In a previous post, we explored the GROUPBY() function as a formula-driven alternative to PivotTables in Excel: Although the GROUPBY() function is useful, it lacks a key feature: the ability to add variables across the columns of a PivotTable. In this post, you’ll see how we can overcome this limitation using the PIVOTBY() function in … Continue reading How to understand the PIVOTBY() function in Excel