Home

Filter Fomula doesn't show in excel 365

%3CLINGO-SUB%20id%3D%22lingo-sub-814123%22%20slang%3D%22en-US%22%3EFilter%20Fomula%20doesn't%20show%20in%20excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-814123%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Everybody%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20setup%20office%20365%20to%20use%20Filter%20Formula%20(%3Dfilter(...)).%20However%20i%20cannot%20find%20it%2C%20only%20FilterXML.%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20what%20happens%20to%20my%20excel%20365%20and%20filter%20formula%3F%20Please%20teach%20me.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-814123%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-814163%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20Fomula%20doesn't%20show%20in%20excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-814163%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F395626%22%20target%3D%22_blank%22%3E%40DoTrungMV%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20now%2C%20you%20will%20need%20to%20join%20the%20%3CA%20href%3D%22https%3A%2F%2Fwww.techrepublic.com%2Farticle%2Fhow-to-join-and-use-microsofts-office-insider-program%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EOffice%20Insider%20Program%3C%2FA%3Eto%20get%20the%20dynamic%20array%20formulas.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
DoTrungMV
Occasional Visitor

Dear Everybody

 

I just setup office 365 to use Filter Formula (=filter(...)). However i cannot find it, only FilterXML.

Does anyone know what happens to my excel 365 and filter formula? Please teach me. 

 

Thank you very much.

1 Reply
Highlighted

@DoTrungMV 

 

For now, you will need to join the Office Insider Program to get the dynamic array formulas.

Related Conversations
Sumifs
Jsbluemoon82 in Excel on
3 Replies
Excel formula similiar to texjoin
Carlo74 in Excel on
0 Replies
everything is black and white in excel
Gold4trees in Excel on
1 Replies
Deleting unwanted rows and columns
chipg900 in Excel on
3 Replies
Excel - Images -
Dmichaud65 in Excel on
1 Replies
Excel Blocked
GuerreroVan in Excel on
0 Replies