UNIQUE Function missing from Excel for Mac

Question

I have Excel for Mac with an office 365 subscription.

Excel version is Version 16.95.1 (25031528) and it's showing as up to date.

Has the UNIQUE function been removed from Excel for Mac? Do I need to do something to enable it?

It doesn't come up in the intellisense when entering the formula in the cell and gives a ?NAME error if I try to add it to the cell anyway.

All help searches indicate that UNIQUE should be available

Answer 1

Have you tried restarting the Mac?

Which specific release of macOS are you using?

Have you been able to use the function in the past?

I suggest that you not post a screen shot of the About Microsoft Excel dialog which includes your email address unless you take the time to block it out. The type of License & whether you or some organization/institution is shown in the Belongs to field is all that is needed.

Answer 2

Dear Kroll_E

Welcome to Microsoft Community.

We understand that you have encountered an error when using the UNIQUE function on Mac.

According to your description, this problem occurred after you tried to update the Excel program to the latest version. We tested it in versions 16.94 and 16.95 and both can correctly pass the perception display prompt and run the formula correctly.

You said that the Name error was displayed after manual input. We are worried that this problem may be caused by problems in detecting formulas and information after the update, which leads to the inability to use this function correctly.

This function itself can be used in Microsoft 365.

Although you indicated that you have a Microsoft 365 subscription, for further confirmation, we also recommend that you try to view the license details displayed through "Excel--About Microsoft Excel". You can also share screenshots with us for review.

At the same time, in order to check whether your Excel program and Office program are running correctly, you can help us try the following operations:

Eliminate interference from third-party add-ons:

Home> Add-ins> Other Add-ins>MY ADD-INS>Remove all add-ins

Reset Office Applications

Delete Office cache and configuration files:

Open Finder and navigate to:

~/Library/Group Containers/UBF8T346G9.Office  

Delete all contents in this folder.

Restart the Excel application.

We also recommend that you try to log out of the account currently logged in to the Office program, and then run the license removal tool to help re-detect the correct license and re-login to the account to see if the function information can be displayed correctly.

Before running, make sure that all office programs have been completely closed and exited, otherwise the operation may be invalid.

You can refer to the information in the following link to download and run the license removal tool:

How to remove Office license files on a Mac - Microsoft Support

You can try to operate and confirm first. If it still doesn't work, we may need to roll back the version or perform other operations through the program's running files and configuration information to further confirm.

Please understand that our initial response may not always solve your problem immediately. However, we will also find a solution together based on the help and more detailed information you provide later.

Best Regards, 

Zenobia.Z | Microsoft Community Support Specialist

Answer 3

Hi,

did you manage to solve the problem? I am having the same issue.. would be very happy to get any tips. For me the issue appeared the second after i updated to macOS 15.4.1. The excel version i am using is 16.95.4

Best

Franziska