This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 74%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Excel for Mac version 16.107.3 (26032814) does not support the unique function.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Answer accepted by question author
The UNIQUE() function most definitely is supported as explained by Hani-Ng but it is an array function. Are you entering the it by pressing Command+return?
If that isn't the problem please explain in detail why you believe it isn't supported. Provide specific examples.
Answer accepted by question author
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 84%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHN%3C/text%3E%3C/svg%3E)
Hi 子恒 张
Although your Excel application is up to date, the UNIQUE function actually depends on your Office license type, rather than the app version.
As noted in the official UNIQUE function - Microsoft Support, this feature is only available for Microsoft 365 subscribers and users with Office 2021 or 2024. It is not supported on older, one-time purchase licenses like Office 2019.
You can check your current license by opening Excel and clicking Excel > About Microsoft Excel in the top menu bar.
If you are using Office 2019, you can save your file to OneDrive and open it in Excel for the Web. The web version is free and fully supports the UNIQUE function.
I hope this information helps. Please let me know if you have further question!
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
This is not a new function. Even though the LTSC versions don't receive features introduced after their release the UNIQUE() function has been around long enough that it should be available in the 2024 LTSC product. If you believe it to be missing please check with your IT folks. The licensee has a great deal of control over what is provided in the LTSC product.