This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello,
I am a user with an Office 365 E5 License. I cannot find the functions: GROUPBY formulas in the Office 365 Version 2410 (Build 18129.20200) that I am currently using. I was able to use the functions: GROUPBY formulas in the previous Version 2409 (Build 18025.20030) Can you help me with this issue?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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.
If you change your update channel to current channel, you can update office to latest version. Then the groupby function will work.
Hello,
when we check from the Admin center, we see it as the current channel.
Note: We can get version 2408, but the version that the formula works with is 2409.
It is based on update channel. Switch to current channel, you will have this function.
Hello;
With the update made in December, the GROUPBY function that came in September was removed and should I downgrade to use this function?
The feature is released on current channel while 18129.20200 is Monthly enterprise channel. If you want to use groupby and pivotby functions, you may contact your IT to switch your update channel to current channel.
Update history for Microsoft 365 Apps (listed by date) - Office release notes | Microsoft Learn