Sep 24 2018 11:31 AM - edited Sep 24 2018 11:32 AM
Hi all,
A new set of functions debuted in the last Insider version of Excel:
They are amazing and useful and can be used to solve many problems!
I think that all of them will be included in the next release of Excel (Excel 2019).
Please watch these videos to take a look at them:
Extract Unique Values in Excel - Episode 2236
Excel Formulas Now Spill - Major Calc Change - Episode 2233
FILTER Function is NEW in Excel
Excel Adds SORT and SORTBY Functions! Episode 2234
SEQUENCE & RANDARRAY in Excel - Episode 2237
Best Regards
Sep 24 2018 01:22 PM
I'm thrilled. :)
Dynamic lists with just one formula.
Jan 28 2019 11:18 PM
I have Office 365 and the =SORTBY() function doesn't seem to be available. Does anyone know how to fix this??
-MikeB123
Jan 29 2019 03:09 AM
You need to be Insider Fast
Jan 29 2019 08:28 AM
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 link.
This feature is expected to be available to Office 365 users in the next few months.
Regards,
Haytham
Jan 29 2019 08:50 AM
To my knowledge it shall be available now for all Office Insiders, not only to the part of them.
Jan 29 2019 09:02 AM
I'm not sure, but this is described in the support article that I mentioned in the previous reply.
Jan 29 2019 02:52 PM
How do I become a "Insider Fast" ?
Jan 29 2019 02:55 PM
Jan 30 2019 07:59 AM - edited Jan 30 2019 07:59 AM
You're welcome!
If you want to join the Office Insider program, check out this link.
And choose the Insider level, not Monthly Channel (Targeted).
Best Regards
Feb 04 2019 04:12 AM