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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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%3CLINGO-SUB%20id%3D%22lingo-sub-868549%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-868549%22%20slang%3D%22en-US%22%3E%3CP%3E1)%20just%20join%20office%20insider%20as%20well%2C%20I%20preferred%20to%20join%20the%20insider%20slow%2C%20as%20the%20FAST%20Version%20was%20very%20unstable%20when%20I%20tried%20and%20messed%20up%20some%20formulas%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2)%20Sadly%20these%20functions%20are%20being%20made%20available%20in%20excel%2C%20when%20Google%20sheets%20been%20offering%20it%20for%20free%20since%20YEARS%2C%20IMPORTRANGE%20etc...%3C%2FP%3E%3CP%3ESTABLE%20AND%20FORGIVING.%20Works%20on%20windows%20and%20Mac%20OS%2C%20Crossplatform.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3)%20I%20have%20a%20business%20premium%20account%2C%20but%20sadly%20I%20feel%20shortchanged%20as%20unbelievable%20features%20are%20available%20in%20google%20sheets%2C%20and%20these%20features%20though%20now%20have%20been%20rolled%20out%20by%20Office%2C%20but%20they%20do%20not%20work%20online%20when%20I%20wish%20to%20collaborate%20with%20my%20team%2C%20which%20is%20very%20primitive.%3C%2FP%3E%3CP%3EThey%20only%20work%20on%20my%20hard%20drive%20office%20insider%20slow%20version.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%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%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-890890%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-890890%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%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20enrolled%20in%20First%20Insiders%20Fast%20with%20Office%20365%20subscription%20and%20I%20also%20see%20that%20SORT()%20and%20FILTER()%20are%20not%20available.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20encountered%20the%20problem%20when%20downloading%20from%20Google%20Sheets%20to%20Excel.%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20more%20information%20on%20when%20the%20functions%20will%20be%20available%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-892226%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-892226%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F419395%22%20target%3D%22_blank%22%3E%40simondavidmiller%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20are%20on%20Insiders%20Fast%20it%20shall%20be%20available.%20Please%20check%20your%20channel%20with%20File-%26gt%3BInfo-%26gt%3BAccount-%26gt%3BAbout%20Excel%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20527px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F135370i37E9C3307C99D372%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIf%20your%20channel%20as%20above%20and%20you%20have%20no%20Dynamic%20Arrays%20functionality%2C%20send%20a%20Frown%20to%20Microsoft%20with%20File-%26gt%3BFeedback%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20349px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F135371i73533AEA895B0AC3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-899202%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-899202%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%3EI'm%20not%20sure%20exactly%20what%20triggered%20it%2C%20but%20found%20FILTER()%2C%20SORT()%20and%20UNIQUE()%20to%20be%20working%20in%20Excel%20this%20morning%2C%20after%20signing%20up%20as%20described.%3CBR%20%2F%3E%3CBR%20%2F%3EHOWEVER%2C%20there's%20one%20caveat.%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20Google%20Sheets%2C%20where%20I%20first%20discovered%20FILTER()%2C%20I'm%20able%20to%20apply%20multiple%20array%20filters%20in%20the%20form%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3D%20FILTER%20(A1%3AA10%2C%20A1%3AA10%26gt%3B0%2C%20B1%3AB10%26gt%3B5%2C%20C1%3AC10%26gt%3B10)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%3CBR%20%2F%3EIt%20looks%20as%20those%20Excel's%20equivalent%20can%20filter%20by%20one%20array%20only.%26nbsp%3B%20Is%20that%20correct%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-899211%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-899211%22%20slang%3D%22en-US%22%3ECan%20FILTERs%20be%20nested%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-899252%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-899252%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F419395%22%20target%3D%22_blank%22%3E%40simondavidmiller%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20use%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DFILTER(A1%3AA10%2C(A1%3AA10%26gt%3B0)*(B1%3AB10%26gt%3B5)*(C1%3AC10%26gt%3B10))%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-899320%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-899320%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%3EWorks!%26nbsp%3B%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-899321%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-899321%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F419395%22%20target%3D%22_blank%22%3E%40simondavidmiller%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFILTER%3As%20could%20be%20nested%2C%20but%20not%20in%20this%20logic%20as%20you%20assume.%20We%20need%20to%20transfer%20filter%20context%20from%20inner%20filter%20to%20outer%20filter%2C%20perhaps%20like%20this%20(first%20in%20mind)%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DFILTER(FILTER(FILTER(A1%3AA10%2CC1%3AC10%26gt%3B10)%2CINDEX(FILTER(A1%3AC10%2CC1%3AC10%26gt%3B10)%2C0%2C2)%26gt%3B5)%2CINDEX(FILTER(FILTER(A1%3AC10%2CC1%3AC10%26gt%3B10)%2CINDEX(FILTER(A1%3AC10%2CC1%3AC10%26gt%3B10)%2C0%2C2)%26gt%3B5)%2C0%2C1)%26gt%3B0)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-899322%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-899322%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F419395%22%20target%3D%22_blank%22%3E%40simondavidmiller%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%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

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

1) just join office insider as well, I preferred to join the insider slow, as the FAST Version was very unstable when I tried and messed up some formulas as well.

 

2) Sadly these functions are being made available in excel, when Google sheets been offering it for free since YEARS, IMPORTRANGE etc...

STABLE AND FORGIVING. Works on windows and Mac OS, Crossplatform.

 

3) I have a business premium account, but sadly I feel shortchanged as unbelievable features are available in google sheets, and these features though now have been rolled out by Office, but they do not work online when I wish to collaborate with my team, which is very primitive.

They only work on my hard drive office insider slow version.

 

 

@Chris2280 

@Sergei Baklan 

I have enrolled in First Insiders Fast with Office 365 subscription and I also see that SORT() and FILTER() are not available.

I encountered the problem when downloading from Google Sheets to Excel.

Any more information on when the functions will be available?

@simondavidmiller 

If you are on Insiders Fast it shall be available. Please check your channel with File->Info->Account->About Excel

image.png

If your channel as above and you have no Dynamic Arrays functionality, send a Frown to Microsoft with File->Feedback

image.png

@Sergei Baklan 

 

I'm not sure exactly what triggered it, but found FILTER(), SORT() and UNIQUE() to be working in Excel this morning, after signing up as described.

HOWEVER, there's one caveat.

In Google Sheets, where I first discovered FILTER(), I'm able to apply multiple array filters in the form:

= FILTER (A1:A10, A1:A10>0, B1:B10>5, C1:C10>10)


It looks as those Excel's equivalent can filter by one array only.  Is that correct?

Can FILTERs be nested?

@simondavidmiller 

You may use

=FILTER(A1:A10,(A1:A10>0)*(B1:B10>5)*(C1:C10>10))

 

@Sergei Baklan 

Works!  Thank you.

@simondavidmiller 

FILTER:s could be nested, but not in this logic as you assume. We need to transfer filter context from inner filter to outer filter, perhaps like this (first in mind)

=FILTER(FILTER(FILTER(A1:A10,C1:C10>10),INDEX(FILTER(A1:C10,C1:C10>10),0,2)>5),INDEX(FILTER(FILTER(A1:C10,C1:C10>10),INDEX(FILTER(A1:C10,C1:C10>10),0,2)>5),0,1)>0)

 

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies