FILTER formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1594937%22%20slang%3D%22en-US%22%3EFILTER%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1594937%22%20slang%3D%22en-US%22%3EIs%20there%20a%20way%20to%20enable%20FILTER%20formula%20in%20previous%20versions%20of%20Excel%3F%20Thank%20you!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1594937%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-1595056%22%20slang%3D%22en-US%22%3ERe%3A%20FILTER%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1595056%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F762660%22%20target%3D%22_blank%22%3E%40PaoxDiiO365%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20what%20MS%20says%20about%20it%3A%3C%2FP%3E%3CP%3E%3CEM%3E%3CSTRONG%3ENote%3A%3C%2FSTRONG%3E%26nbsp%3BThis%20function%26nbsp%3Bis%20currently%20available%20to%20Microsoft%20365%20subscribers%20in%20Current%20Channel.%20It%20will%20be%20available%20to%20Microsoft%20365%20subscribers%20in%20Semi-Annual%20Enterprise%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%22%3EWhen%20do%20I%20get%20the%20newest%20features%20in%20for%20Microsoft%26nbsp%3B365%3C%2FA%3E.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20if%20you%20are%20not%20an%20MS365%20subscriber%2C%20you%20will%20not%20be%20able%20to%20use%20FILTER.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Is there a way to enable FILTER formula in previous versions of Excel? Thank you!
1 Reply

@PaoxDiiO365 

This is what MS says about it:

Note: This function is currently available to Microsoft 365 subscribers in Current Channel. It will be available to Microsoft 365 subscribers in Semi-Annual Enterprise 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.

 

So, if you are not an MS365 subscriber, you will not be able to use FILTER.