New aggregation functions in Excel: GROUPBY and PIVOTBY

Microsoft

Aug 25, 2024

(Originally published on December 4, 2023 by Joe McDaid) Hey, Microsoft 365 Insiders! I’m Joe McDaid, a Product Manager on the Excel team, and I’m excited to announce the availability of two n...

Updated Jan 31, 2025

Version 2.0

excel

mac

Linda_C

Microsoft

Joined August 16, 2016

View Profile

Microsoft 365 Insider Blog

Welcome to the Microsoft 365 Insider blog! Get updates and insights about Microsoft 365 features as they release to preview channels on Windows, the web, Mac, iOS, and Android.
Learn about the Microsoft 365 Insider program at https://aka.ms/MSFT365InsiderProgram
For technical support and break/fix questions, please visit Microsoft Support Community.

Blog Post

New aggregation functions in Excel: GROUPBY and PIVOTBY