Home

Excel SORT() and FILTER() functions are missing

%3CLINGO-SUB%20id%3D%22lingo-sub-533484%22%20slang%3D%22en-US%22%3EExcel%20SORT()%20and%20FILTER()%20functions%20are%20missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-533484%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecurrently%20i%20am%20searching%20for%20the%20SORT()%20and%20FILTER()%20function%20in%20excel.%20I've%20read%20that%20it%20should%20be%20available%20in%20Office%20365%20Pro%20Plus.%20But%20when%20i%20am%20typing%20in%20the%20function%20into%20the%20cells%2C%20there%20is%20no%20recommendation%20shown%20to%20choose%20the%20function.%20Now%20i%20have%20the%20question%2C%20where%20can%20I%20find%20these%20functions%20or%20how%20can%20I%20activate%20them%3F%20I%20updated%20my%20Office%2C%20so%20it%20has%20the%20latest%20update%20and%20I%20am%20also%20using%20Excel%202016.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20helping!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EChris%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-533484%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-533589%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20SORT()%20and%20FILTER()%20functions%20are%20missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-533589%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F334282%22%20target%3D%22_blank%22%3E%40Chris2280%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHi%20Chris%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOnly%20Office365%20subscription%20is%20not%20enough%2C%20you%20have%20to%20join%20Office%20Insiders%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Finsider.office.com%2Fen-us%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Finsider.office.com%2Fen-us%2F%3C%2FA%3E%26nbsp%3Band%20install%20Insiders%20(Fast)%20build.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-533735%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20SORT()%20and%20FILTER()%20functions%20are%20missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-533735%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%20Sergei%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%20for%20your%20fast%20response.%20Unfortunately%20the%20link%20does%20not%20work%20respectivly%20does%20not%20loading.%20I%20tried%20to%20access%20over%20the%20google%20link%2C%20but%20it%20does%20not%20work%20either.%20Maybe%20its%20just%20the%20server.%20But%20i%20will%20try%20to%20install%20the%20insider%20(fast)%20build%20und%20hopefully%20it%20works.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-533752%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20SORT()%20and%20FILTER()%20functions%20are%20missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-533752%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F334282%22%20target%3D%22_blank%22%3E%40Chris2280%3C%2FA%3E%26nbsp%3B%2C%20strange%2C%20it%20shall%20work.%20Try%20simply%20insider.office.com%20or%20google%20%22Office%20365%20insider%20program%22.%20Actually%20this%20site%20gives%20an%20information%20about%20Insiders%20program%20and%20somewhere%20it%20shall%20be%20instruction%20how%20to%20join%20and%20install%20insiders%20version%20-%20it%20depends%20on%20your%20platform%20and%20are%20you%20on%20personal%20or%20business%20subscription.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-855728%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20SORT()%20and%20FILTER()%20functions%20are%20missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-855728%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Excel%20SORT%20function%20is%20one%20of%206%20released%20in%20July%202019%20to%20build%26nbsp%3B%3CSTRONG%3EVersion%201907%20(Build%2011901.20176)%26nbsp%3B%3C%2FSTRONG%3Ebut%20I%20am%20on%20a%20later%20build%20(%3CSTRONG%3EVersion%201908%20Build%2011929.20300%3C%2FSTRONG%3E)%20and%20I%20still%20cannot%20see%20these%20new%20formulas%20available.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-856091%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20SORT()%20and%20FILTER()%20functions%20are%20missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-856091%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408965%22%20target%3D%22_blank%22%3E%40Daniel_Engler%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThese%20days%20build%20number%20practically%20means%20nothing.%20It%20only%20indicates%20that%20starting%20from%20this%20build%20you%20have%20a%20chance%20to%20receive%20this%20or%20that%20new%20functionality.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENew%20functionality%20is%20deployed%20gradually%20by%20channels.%20First%20Insiders%20Fast%2C%20next%20Monthly%20Targeted%2C%20next%20Monthly%20channel%2C%20etc.%20You%20may%20have%20some%20build%20on%20Monthly%20channel%20but%20have%20no%20new%20functionality%20witch%20another%20person%20on%20Monthly%20Targeted%20received%20with%20the%20same%20build.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMoreover%2C%20gradual%20deployment%20is%20within%20same%20channel%20as%20well.%20You%20may%20be%20on%20the%20same%20channel%20and%20on%20the%20same%20build%20with%20another%20person%2C%20but%20one%20of%20you%20already%20have%20new%20functionality%2C%20another%20one%20not.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20take%20months%20to%20deploy%20functionality%20to%20everyone%20within%20same%20channel.%20I%20don't%20know%20what%20is%20the%20exact%20mechanism%20of%20deployment%2C%20perhaps%20you%20receive%20some%20registry%20key%20when%20next%20time%20login%20to%20Office.%20What%20is%20the%20logic%20on%20server%20side%2C%20when%20and%20to%20whom%20to%20flick%20the%20switch.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Chris2280
New Contributor

Hello there,

 

currently i am searching for the SORT() and FILTER() function in excel. I've read that it should be available in Office 365 Pro Plus. But when i am typing in the function into the cells, there is no recommendation shown to choose the function. Now i have the question, where can I find these functions or how can I activate them? I updated my Office, so it has the latest update and I am also using Excel 2016.

 

Thank you for your helping!

 

Best regards

 

Chris

5 Replies

@Chris2280 ,

 

Hi Chris,

 

Only Office365 subscription is not enough, you have to join Office Insiders https://insider.office.com/en-us/ and install Insiders (Fast) build.

@Sergei Baklan 

 

Hello Sergei,

 

thank you for your fast response. Unfortunately the link does not work respectivly does not loading. I tried to access over the google link, but it does not work either. Maybe its just the server. But i will try to install the insider (fast) build und hopefully it works.

@Chris2280 , strange, it shall work. Try simply insider.office.com or google "Office 365 insider program". Actually this site gives an information about Insiders program and somewhere it shall be instruction how to join and install insiders version - it depends on your platform and are you on personal or business subscription.

@Sergei Baklan 

 

The Excel SORT function is one of 6 released in July 2019 to build Version 1907 (Build 11901.20176) but I am on a later build (Version 1908 Build 11929.20300) and I still cannot see these new formulas available.

@Daniel_Engler 

 

These days build number practically means nothing. It only indicates that starting from this build you have a chance to receive this or that new functionality.

 

New functionality is deployed gradually by channels. First Insiders Fast, next Monthly Targeted, next Monthly channel, etc. You may have some build on Monthly channel but have no new functionality witch another person on Monthly Targeted received with the same build.

 

Moreover, gradual deployment is within same channel as well. You may be on the same channel and on the same build with another person, but one of you already have new functionality, another one not.

 

That could take months to deploy functionality to everyone within same channel. I don't know what is the exact mechanism of deployment, perhaps you receive some registry key when next time login to Office. What is the logic on server side, when and to whom to flick the switch.

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies