Home

Good News: Awesome new functions coming to Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-261471%22%20slang%3D%22en-US%22%3EGood%20News%3A%20Awesome%20new%20functions%20coming%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-261471%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20new%20set%20of%20functions%20debuted%20in%20the%20last%20Insider%20version%20of%20Excel%3A%3C%2FP%3E%3CUL%3E%3CLI%3ESORT%20%26amp%3B%20SORTBY%3C%2FLI%3E%3CLI%3EUNIQUE%3C%2FLI%3E%3CLI%3ESEQUENCE%20%26amp%3B%20RANDARRAY%3C%2FLI%3E%3CLI%3EFILTER%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThey%20are%20amazing%20and%20useful%20and%20can%20be%20used%20to%20solve%20many%20problems!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%20class%3D%22%22%3EI%20think%20that%20all%20of%20them%20will%20be%20included%20in%20the%20next%20release%20of%20Excel%20(Excel%202019).%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20watch%20these%20videos%20to%20%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%20class%3D%22%22%3Etake%20a%20look%20at%20them%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%20class%3D%22%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dvy8y4CN-IHY%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EExtract%20Unique%20Values%20in%20Excel%20-%20Episode%202236%3C%2FA%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%20class%3D%22%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DZmLu0vMRrGs%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EExcel%20Formulas%20Now%20Spill%20-%20Major%20Calc%20Change%20-%20Episode%202233%3C%2FA%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%20class%3D%22%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dm-w7fJTudig%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EFILTER%20Function%20is%20NEW%20in%20Excel%3C%2FA%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%20class%3D%22%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DATJgGWnS7Kg%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EExcel%20Adds%20SORT%20and%20SORTBY%20Functions!%20Episode%202234%3C%2FA%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%20class%3D%22%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DQN8KJmRLilo%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESEQUENCE%20%26amp%3B%20RANDARRAY%20in%20Excel%20-%20Episode%202237%3C%2FA%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%20class%3D%22%22%3EBest%20Regards%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-261471%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-330153%22%20slang%3D%22en-US%22%3ERe%3A%20Good%20News%3A%20Awesome%20new%20functions%20coming%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-330153%22%20slang%3D%22en-US%22%3EYou%20need%20the%20%22Insider%22%20version%20of%20365.%20Hopefully%2C%20it%20will%20be%20generally%20available%20to%20everyone%20before%20Q2%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-328026%22%20slang%3D%22en-US%22%3ERe%3A%20Good%20News%3A%20Awesome%20new%20functions%20coming%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-328026%22%20slang%3D%22en-US%22%3E%3CP%3EYou're%20welcome!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20want%20to%20join%20the%20Office%20Insider%20program%2C%20check%20out%20this%20%3CA%20href%3D%22https%3A%2F%2Finsider.office.com%2Fen-us%2F%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Elink%3C%2FA%3E.%3C%2FP%3E%3CP%3EAnd%20choose%20the%20%3CSTRONG%3EInsider%20%3C%2FSTRONG%3Elevel%3CSTRONG%3E%2C%20%3C%2FSTRONG%3Enot%20%3CSTRONG%3EMonthly%20Channel%20(Targeted)%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-327656%22%20slang%3D%22en-US%22%3ERe%3A%20Good%20News%3A%20Awesome%20new%20functions%20coming%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327656%22%20slang%3D%22en-US%22%3ENevermind.%20I%20found%20it.%20Thanks%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-327653%22%20slang%3D%22en-US%22%3ERe%3A%20Good%20News%3A%20Awesome%20new%20functions%20coming%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327653%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20become%20a%20%22Insider%20Fast%22%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-327375%22%20slang%3D%22en-US%22%3ERe%3A%20Good%20News%3A%20Awesome%20new%20functions%20coming%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327375%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EI'm%20not%20sure%2C%20but%20this%20is%20described%20in%20the%20support%20article%20that%20I%20mentioned%20in%20the%20previous%20reply.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-327355%22%20slang%3D%22en-US%22%3ERe%3A%20Good%20News%3A%20Awesome%20new%20functions%20coming%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327355%22%20slang%3D%22en-US%22%3E%3CP%3ETo%20my%20knowledge%20it%20shall%20be%20available%20now%20for%20all%20Office%20Insiders%2C%20not%20only%20to%20the%20part%20of%20them.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-327336%22%20slang%3D%22en-US%22%3ERe%3A%20Good%20News%3A%20Awesome%20new%20functions%20coming%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327336%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F273790%22%20target%3D%22_blank%22%3E%40MikeB123%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20function%20is%20part%20of%20the%20several%20functions%20are%20known%20as%20(Spilled%20array%20functions)%20and%20they%20are%20part%20of%20the%20upcoming%20feature%20(Dynamic%20arrays).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20this%20feature%20is%20still%20in%20beta%20and%20is%20only%20available%20to%20a%20portion%20of%20Office%20Insiders.%3C%2FP%3E%3CP%3EFor%20more%20info%2C%20please%20check%20out%20this%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fsortby-function-cd2d7a62-1b93-435c-b561-d6a35134f28f%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Elink%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EThis%20feature%20is%20expected%20to%20be%20available%20to%20Office%20365%20users%20in%20the%20next%20few%20months.%3C%2FSPAN%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EHaytham%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-327129%22%20slang%3D%22en-US%22%3ERe%3A%20Good%20News%3A%20Awesome%20new%20functions%20coming%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327129%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20need%20to%20be%20Insider%20Fast%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-327047%22%20slang%3D%22en-US%22%3ERe%3A%20Good%20News%3A%20Awesome%20new%20functions%20coming%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327047%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20Office%20365%20and%20the%20%3DSORTBY()%20function%20doesn't%20seem%20to%20be%20available.%20Does%20anyone%20know%20how%20to%20fix%20this%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-MikeB123%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-261587%22%20slang%3D%22en-US%22%3ERe%3A%20Good%20News%3A%20Awesome%20new%20functions%20coming%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-261587%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20thrilled.%20%3A-)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDynamic%20lists%20with%20just%20one%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Haytham Amairah
Trusted Contributor

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

10 Replies

I'm thrilled. :-)

 

Dynamic lists with just one formula.

 

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

 

-MikeB123

You need to be Insider Fast

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

To my knowledge it shall be available now for all Office Insiders, not only to the part of them.

I'm not sure, but this is described in the support article that I mentioned in the previous reply.

How do I become a "Insider Fast" ?

Nevermind. I found it. Thanks

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

 

You need the "Insider" version of 365. Hopefully, it will be generally available to everyone before Q2
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies