Introducing two new Excel functions: GROUPBY and PIVOTBY

Two exciting new functions were announced last week: GROUPBY and PIVOTBY.

These provide a powerful yet simple way to perform data aggregations using a single formula.

❖ GROUPBY — aggregates a range of values by row group.
❖ PIVOTBY — aggregates a range of values by row and column group.

One of the downsides of regular pivot tables is having to right-click on one and select Refresh to update it. These functions solve that problem by dynamically updating any time you change the source data.

Both are currently only available to Microsoft 365 Insiders on the Beta Channel, so you'll have to wait a while before they reach the production version.

You might also notice a few bugs, such as column headings not appearing and missing AutoComplete boxes for arguments. No doubt these issues will be ironed out, though!



If you've already played around with the functions, what are your initial impressions?

#exceleration #excel #microsoftexcel #excelformulas #exceltips #exceltricks #globalexcelsummit

---

The Global Excel Summit is the world's largest gathering of Microsoft Excel users and experts.

Find us on:

[idsoftware]

Not showing up in Microsoft® Excel® for Microsoft 365 MSO (Version 2308 Build 16.0.16731.20496) 64-bit

[rajkumarjain]

Unable to locate this functions in office 365

[ivanbork]

good news. looking forward to that
Thanks

[josecarlossalgado]

When will the formula be available on the normal Microsoft 365 product?

[testfun]

how come i am not able to use it ? when can we use them ??'

[paweniedbaa]

Does this function exist in excel 2021 or only on 365