how to get the PIVOTBY function working on my excel

Question

how to get the PIVOTBY function working on my excel?

Answer 1

Hi,

What version of Office did you use?

As the article said the function is currently available to Beta Channel users running: 

• Windows: Version 2312 (Build 17116.10000) or later 
• Mac: 16.80 (Build 23111917) or later 

https://insider.microsoft365.com/en-us/blog/new-aggregation-functions-in-excel-groupby-and-pivotby

You can try to join the Microsoft 365 Insider Program to get the function:

https://insider.microsoft365.com/en-us/join/windows

Hope the information is helpful.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.