Forum Discussion
Good News: Awesome new functions coming to Excel
I have Office 365 and the =SORTBY() function doesn't seem to be available. Does anyone know how to fix this??
-MikeB123
- SWill856Feb 04, 2019Copper ContributorYou need the "Insider" version of 365. Hopefully, it will be generally available to everyone before Q2
- Haytham AmairahJan 29, 2019Silver Contributor
Hi MikeB123,
This function is part of the several functions are known as (Spilled array functions) and they are part of the upcoming feature (Dynamic arrays).
But this feature is still in beta and is only available to a portion of Office Insiders.
For more info, please check out this https://support.office.com/en-us/article/sortby-function-cd2d7a62-1b93-435c-b561-d6a35134f28f.
This feature is expected to be available to Office 365 users in the next few months.
Regards,
Haytham
- SergeiBaklanJan 29, 2019Diamond Contributor
To my knowledge it shall be available now for all Office Insiders, not only to the part of them.
- Haytham AmairahJan 29, 2019Silver Contributor
I'm not sure, but this is described in the support article that I mentioned in the previous reply.
- SergeiBaklanJan 29, 2019Diamond Contributor
You need to be Insider Fast