I can't find filter function in office 2019

%3CLINGO-SUB%20id%3D%22lingo-sub-1442317%22%20slang%3D%22en-US%22%3EI%20can't%20find%20filter%20function%20in%20office%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1442317%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20can't%20find%20filter%20function%20in%20office%202019%2C%20I%20made%20updates%20and%20read%20about%20the%20inside%20office%20but%20it's%20not%20available.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20advice%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3EHisham%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1442317%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1442351%22%20slang%3D%22en-US%22%3ERe%3A%20I%20can't%20find%20filter%20function%20in%20office%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1442351%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F689925%22%20target%3D%22_blank%22%3E%40heshamsheeha%3C%2FA%3E%26nbsp%3BMS%20support%20pages%20indicate%20the%20following%20regarding%20FILTER%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CSTRONG%3ENote%3A%3C%2FSTRONG%3E%3CSPAN%3E%3C%2FSPAN%3E%3C%2FSTRONG%3E%26nbsp%3BThis%20function%26nbsp%3Bis%20currently%20available%20to%20Microsoft%20365%20subscribers%20in%20the%20Monthly%20channel.%20It%20will%20be%20available%20to%20Microsoft%20365%20subscribers%20in%20the%20Semi-Annual%20channel%20starting%20in%20July%202020.%20For%20more%20information%20on%20how%20features%20are%20rolled%20out%20to%20Microsoft%20365%20subscribers%2C%20see%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-gb%2Ff1%2Ftopic%2Fwhen-do-i-get-the-newest-features-for-microsoft-365-da36192c-58b9-4bc9-8d51-bb6eed468516%3FNS%3DMACEXCEL%26amp%3BVersion%3D90%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EWhen%20do%20I%20get%20the%20newest%20features%20in%20for%20Microsoft%26nbsp%3B365%3C%2FA%3E%3CSPAN%3E.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1442404%22%20slang%3D%22en-US%22%3ERe%3A%20I%20can't%20find%20filter%20function%20in%20office%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1442404%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3Bas%20you%20are%20saying%20it's%20not%20available%20for%20Microsoft%202019%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1442409%22%20slang%3D%22en-US%22%3ERe%3A%20I%20can't%20find%20filter%20function%20in%20office%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1442409%22%20slang%3D%22en-US%22%3EMicrosoft%20Office%202019%20the%20filter%20function%20is%20not%20available%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1445268%22%20slang%3D%22en-US%22%3ERe%3A%20I%20can't%20find%20filter%20function%20in%20office%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445268%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F689925%22%20target%3D%22_blank%22%3E%40heshamsheeha%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20FILTER%20Function%20is%20one%20of%20the%20Six%20Dynamic%20Array%20functions%20functions%20and%20they%20are%20currently%20available%20to%20subscribers%20on%20the%26nbsp%3B%3CSTRONG%3EInsiders%20Fast%26nbsp%3B%3C%2FSTRONG%3Eand%20Microsoft%20365%26nbsp%3B%3CSTRONG%3EMonthly%20Channel%20E3%2FE5%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESemi-Annual%20and%20Annual%20Channels%20to%20follow%20suit%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Abiola1_0-1591450665390.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197018i410FF65BFB8B3B94%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Abiola1_0-1591450665390.png%22%20alt%3D%22Abiola1_0-1591450665390.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EMaybe%20Microsoft%20will%20include%20it%20in%20Office%202022%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1445543%22%20slang%3D%22en-US%22%3ERe%3A%20I%20can't%20find%20filter%20function%20in%20office%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445543%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20the%20whole%20filter%20function%20is%20not%20appearing%20in%20the%20excel%202019%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20it%20available%20without%20subscribe%3C%2FP%3E%3CP%3E%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHisham%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1445546%22%20slang%3D%22en-US%22%3ERe%3A%20I%20can't%20find%20filter%20function%20in%20office%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445546%22%20slang%3D%22en-US%22%3E%3CP%3Ehow%20to%20subscribe%20to%20Insiders%20Fast%20and%20Microsoft%20365%20Monthly%20Channel%20E3%2FE5%26nbsp%3Band%20i%20install%20already%20office%202019%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1445556%22%20slang%3D%22en-US%22%3ERe%3A%20I%20can't%20find%20filter%20function%20in%20office%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445556%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F689925%22%20target%3D%22_blank%22%3E%40heshamsheeha%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20difference%20between%202019%20and%20365%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fwhat-s-the-difference-between-microsoft-365-and-office-2019-ed447ebf-6060-46f9-9e90-a239bd27eb96%3Fomkt%3Den-US%26amp%3Bui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EWhat's%20the%20difference%20between%20Microsoft%20365%20and%20Office%202019%3F%3C%2FA%3E%26nbsp%3BIn%20particular%2C%20it%20says%202019%20never%20will%20have%20new%20functionality.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHow%20to%20upgrade%20it's%20better%20to%20ask%20your%20local%20reseller%2C%20afraid%20you%20shall%20just%20to%20purchase%20the%20subscription.%20Bit%20more%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fhow-do-i-upgrade-office-ee68f6cf-422f-464a-82ec-385f65391350%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EHow%20do%20I%20upgrade%20Office%3F%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhich%20version%20it's%20depends%20on%20how%20are%20you%20going%20to%20use%20Office.%20From%20dynamic%20array%20functionality%20point%20of%20view%20it's%20not%20necessary%20enterprise%20E3%2FE5%2C%20that%20could%20be%20Family%20or%20others%2C%20it's%20important%20to%20updater%20from%20semi-annual%20on%20current%20or%20beta%20channels.%20However%2C%20dynamic%20arrays%20will%20be%20on%20semi-annual%20as%20well%20in%20couple%20of%20months%20or%20so.%20Functionality%20for%20concrete%20subscription%20it's%20better%20to%20check%20additionally.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1445576%22%20slang%3D%22en-US%22%3ERe%3A%20I%20can't%20find%20filter%20function%20in%20office%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445576%22%20slang%3D%22en-US%22%3EHello%2C%20%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20read%20up%20how%20to%20upgrade%20from%20the%20article%20in%20the%20link%20below%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fhow-do-i-upgrade-office-ee68f6cf-422f-464a-82ec-385f65391350%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fhow-do-i-upgrade-office-ee68f6cf-422f-464a-82ec-385f65391350%3C%2FA%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi,

I can't find filter function in office 2019, I made updates and read about the inside office but it's not available.

 

Please advice?

 

Regards

Hisham

8 Replies

@heshamsheeha MS support pages indicate the following regarding FILTER:

 

Note: This function is currently available to Microsoft 365 subscribers in the Monthly channel. It will be available to Microsoft 365 subscribers in the Semi-Annual channel starting in July 2020. For more information on how features are rolled out to Microsoft 365 subscribers, see When do I get the newest features in for Microsoft 365.

@Riny_van_Eekelen as you are saying it's not available for Microsoft 2019

Microsoft Office 2019 the filter function is not available

Hello@heshamsheeha 

 

The FILTER Function is one of the Six Dynamic Array functions functions and they are currently available to subscribers on the Insiders Fast and Microsoft 365 Monthly Channel E3/E5

 

Semi-Annual and Annual Channels to follow suit

Abiola1_0-1591450665390.png

Maybe Microsoft will include it in Office 2022

 

Dear the whole filter function is not appearing in the excel 2019@Abiola1 

is it available without subscribe

?

 

Thanks

 

Hisham

 

how to subscribe to Insiders Fast and Microsoft 365 Monthly Channel E3/E5 and i install already office 2019 @Abiola1 

@heshamsheeha 

The difference between 2019 and 365 is here What's the difference between Microsoft 365 and Office 2019? In particular, it says 2019 never will have new functionality.

 

How to upgrade it's better to ask your local reseller, afraid you shall just to purchase the subscription. Bit more is here How do I upgrade Office? 

 

Which version it's depends on how are you going to use Office. From dynamic array functionality point of view it's not necessary enterprise E3/E5, that could be Family or others, it's important to updater from semi-annual on current or beta channels. However, dynamic arrays will be on semi-annual as well in couple of months or so. Functionality for concrete subscription it's better to check additionally.