Forum Discussion
Good News: Awesome new functions coming to Excel
Hi all, A new set of functions debuted in the last Insider version of Excel: SORT & SORTBY UNIQUE SEQUENCE & RANDARRAY FILTER They are amazing and useful and can be used to solve many p...
I have Office 365 and the =SORTBY() function doesn't seem to be available. Does anyone know how to fix this??
-MikeB123
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