Forum Discussion

Silver Contributor

Sep 24, 2018

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...

excel

Formulas and Functions

office 365

MikeB123

Copper Contributor

Jan 29, 2019

I have Office 365 and the =SORTBY() function doesn't seem to be available. Does anyone know how to fix this??

-MikeB123

Haytham Amairah

Silver Contributor

Jan 29, 2019

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

SergeiBaklan
Diamond Contributor
Jan 29, 2019
To my knowledge it shall be available now for all Office Insiders, not only to the part of them.
- Haytham Amairah
  Silver Contributor
  Jan 29, 2019
  I'm not sure, but this is described in the support article that I mentioned in the previous reply.