At one point, Pivot Tables were the greatest feature in Excel, but as with most tools and tricks, that’s no longer the case. Instead of setting up a Pivot Table, adjusting the layout, and refreshing it every time you add or replace figures, you can now write a single formula that produces the same results with far less effort and time. Using PIVOTBY, you can group summaries across two axes and aggregate values, just as you would with a Pivot Table. However, because everything lives inside a formula, your summaries will update automatically, making it easier and faster for you to identify trends in your data. PIVOTBY isn’t just another pivot table It’s a single formula that builds a full summary instantly Screenshot by Ada Despite producing similar-looking outputs, PIVOTBY has nothing to do with Excel’s traditional PivotTable feature. It’s a dynamic array formula available in Excel for Microsoft 365, Excel 2024, and Excel 2021 (including Mac versions) that groups, aggregates, sorts, and filters your data in a single step. You write one formula, press …