Jun 16 2019 03:34 PM
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.
Please can someone provide some assistance. Many thanks in advance for your prompt reply.
Jun 17 2019 01:30 AM
Jun 17 2019 02:06 AM
@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.
Have you come across this before?
Jun 17 2019 03:39 AM
SolutionJun 17 2019 06:41 AM
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.
May 21 2021 06:12 AM
I have this same problem, but my case is even more bizarre. I had the functions (in particular Unique and Filter) when I shut down shop last night. I have had them now for a couple of months (or at least I discovered them a few months ago. But this morning, they are now longer in the list of available functions.
To make matters even more strange, I read somewhere that the problem is connected to the language version of Excel you are using. I put my Excel in French and the fonctions come back. But I don't want my Excel to be in French. ... or German or any other language that I happen to speak.
Please can someone help !!!
Lost in Lockdown with out a unique filter to save my sole !!!
Jun 17 2019 03:39 AM
Solution