Hi,
I am a long time user of Excel on Mac OS, using Office 365 and the latest Excel v16.52
For the past couple of weeks I'm experiencing the weird disappearance of the function UNIQUE() from Excel function builder.
1- First, I used the function like =UNIQUE(Table_Vuln_Current_Week[App Name];FALSE)
to return a list of application names, and it worked fine
2- The next day, I open the same workbook and Excel displays something like
=_xlfn.UNIQUE(Table_Vuln_Current_Week[App Name];FALSE)
it is greyed out and if I want to edit or re-enter the formula, I get a #NAME error
3- Yesterday I got the latest update installed and the function was working again, until this morning
If I try to create a new worksheet to run a test of this function, I get the #NAME error
4- I closed Excel, re-opened my work file and there it is, the formula is no longer showing the _xlfn. prefix
I use tons of formulas in my workbook and I only get this issue with the UNIQUE() and IFS functions
Has anyone encountered such weird behaviour?
Thank you
