Forum Discussion
Friso1966
Jun 16, 2019Copper Contributor
Missing functions in Excel
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 functio...
- Jun 17, 2019Datedif is the only function not available in the list (for historic reasons) that is actually there. Just type the entire function name.
RvL_richy
May 21, 2021Copper Contributor
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 !!!