SOLVED
Home

Missing functions in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-694868%22%20slang%3D%22en-US%22%3EMissing%20functions%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-694868%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20currently%20using%20the%20latest%20build%20of%20Excel%20as%20part%20of%20my%20Office%20365%20subscription.%20I%20have%20noticed%20that%20a%20number%20of%20functions%20that%20I%20would%20like%20to%20use%20within%20formulas%20are%20not%20available.%20The%20functions%20that%20I%20am%20currently%20attempting%20to%20use%20are%20DATEDIF%2C%20SORT%2C%20UNIQUE%20and%20FILTER.%20I%20suspect%20that%20there%20are%20quite%20a%20few%20other%20functions%20that%20are%20also%20unavailable.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20already%20chatted%20with%20a%20Microsoft%20support%20member%20who%20confirmed%20that%20the%20functions%20are%20not%20available%20when%20it%20attempt%20to%20type%20them%20into%20a%20selected%20cell.%20I%20am%20currently%20a%20member%20of%20the%20Insiders%20program%20(Monthly%20Targeted)%20and%20I%20have%20updated%20my%20copy%20of%20Excel%20to%20the%20latest%20version.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20667px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F118243i79152B54EC2332F5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Annotation%202019-06-17%20023139.png%22%20title%3D%22Annotation%202019-06-17%20023139.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20can%20someone%20provide%20some%20assistance.%20Many%20thanks%20in%20advance%20for%20your%20prompt%20reply.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-694868%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-695309%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20functions%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-695309%22%20slang%3D%22en-US%22%3ETo%20get%20the%20SORT%2C%20FILTER%20and%20UNIQUE%20functions%20you%20must%20be%20on%20Insider%20FAST%20and%20on%20top%20of%20that%20you%20must%20be%20among%20the%20people%20who%20have%20been%20(randomly!)%20selected%20to%20receive%20the%20Dynamic%20Array%20capabilities.%20DATEDIF%20should%20work%20on%20your%20Excel%20too%2C%20just%20type%20the%20function%20manually.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-695350%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20functions%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-695350%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3BThank%20you%20for%20your%20response%20and%20for%20outlining%20the%20requirements%20for%20using%20SORT%2C%20UNIQUE%20and%20FILTER.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%2C%20DATEDIF%20is%20still%20missing%20as%20shown%20whenever%20I%20try%20to%20type%20the%20function%20into%20a%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20211px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F118261iFCE5826270FEFC10%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Annotation%202019-06-17%20130236.png%22%20title%3D%22Annotation%202019-06-17%20130236.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHave%20you%20come%20across%20this%20before%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-695593%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20functions%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-695593%22%20slang%3D%22en-US%22%3EDatedif%20is%20the%20only%20function%20not%20available%20in%20the%20list%20(for%20historic%20reasons)%20that%20is%20actually%20there.%20Just%20type%20the%20entire%20function%20name.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-696116%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20functions%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-696116%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnbelievable.%20It%20works%20now.%20I%20used%20DATEDIF%20without%20it%20appearing%20in%20the%20list%20and%20it%20works%20as%20expected.%20Thank%20you%20for%20your%20assistance%20with%20this%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Friso1966
New Contributor

I am currently using the latest build of Excel as part of my Office 365 subscription. I have noticed that a number of functions that I would like to use within formulas are not available. The functions that I am currently attempting to use are DATEDIF, SORT, UNIQUE and FILTER. I suspect that there are quite a few other functions that are also unavailable.

 

I have already chatted with a Microsoft support member who confirmed that the functions are not available when it attempt to type them into a selected cell. I am currently a member of the Insiders program (Monthly Targeted) and I have updated my copy of Excel to the latest version.

Annotation 2019-06-17 023139.png

 

Please can someone provide some assistance. Many thanks in advance for your prompt reply.

4 Replies
To get the SORT, FILTER and UNIQUE functions you must be on Insider FAST and on top of that you must be among the people who have been (randomly!) selected to receive the Dynamic Array capabilities. DATEDIF should work on your Excel too, just type the function manually.

@Jan Karel Pieterse Thank you for your response and for outlining the requirements for using SORT, UNIQUE and FILTER.

 

Unfortunately, DATEDIF is still missing as shown whenever I try to type the function into a cell.

 

Annotation 2019-06-17 130236.png

Have you come across this before?

Highlighted
Solution
Datedif is the only function not available in the list (for historic reasons) that is actually there. Just type the entire function name.

@Jan Karel Pieterse 

 

Unbelievable. It works now. I used DATEDIF without it appearing in the list and it works as expected. Thank you for your assistance with this problem.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies