Where is pivot by function

Question

Where is pivot by function

Anonymous

I am running office 365 on windows 11 and am a member of insider. I hear a lot about the pivot by function, but it is not in my formulas as available. I have updated the software, but still can't see it - i am in Australia. Any suggestions, i would like to see it for myself

I have reset my ribbon bar, updated my application. That did not work. I uninstalled office, restarted my machine. Reinstalled office 365, still no luck

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

2 answers

Answer 1

Good day, WarrenOrlandi-Phillips - WPO.

Welcome to the Microsoft Community Forum. Please accept our warmest greetings and our sincerest hope that all is well.

The PIVOTBY function is currently rolling out to users enrolled in the beta channel for Excel. Refer to link below.

https://techcommunity.microsoft.com/t5/excel-blog/new-aggregation-functions-groupby-and-pivotby/ba-p/3965765

With that in mind, can you tell me what version of Excel are you using? I specifically need the product name and Version number as highlighted in the guide and photo below.

https://support.microsoft.com/en-us/office/about-office-what-version-of-office-am-i-using-932788b8-a3ce-44bf-bb09-e334518b8b19

Also, you are referring to PIVOTBY as described in the guide below, right?

https://support.microsoft.com/en-us/office/pivotby-function-de86516a-90ad-4ced-8522-3a25fac389cf

If you already have the required build of Microsoft 365 Insider (beta channel) and still do not have the PIVOTBY function, you may want to post a question over at our Microsoft Q&A website using the link below. They may have the experts that can help you.

https://learn.microsoft.com/en-us/answers/tags/9/m365

If you have additional questions or concerns, please let me know so we can explore other solutions.

Hope to hear from you soon.

Sincerely,

Glenn Rue

Forum Moderator

Microsoft Community

Answer 2

Hello!

We haven't heard from you, so we assume that your issue has already been addressed. We will not be monitoring this thread moving forward so, if you need further assistance, please create a new thread to discuss these concerns by clicking this link:

https://answers.microsoft.com/en-us/newthread?threadtype=Questions&cancelurl=%2Fen-us%2F

Thank you for understanding.

Respectfully,

Glenn

Share via

Where is pivot by function

2 answers