Oct 26 2021 04:49 AM
Hi,
According to
https://support.microsoft.com/en-us/office/unique-function-c5ab87fd-30a3-4ce9-9d1a-40204fb85e1e?ui=en-us&rs=en-us&ad=us
It is not clear which versions of office have the UNIQUE function. It says "This function is currently available only to Microsoft 365 subscribers."
I have a Office 365 Enterprise subscription and noticed that the UNIQUE function exists on the Office version "Microsoft 365 Apps for Enterprise" but not on "Microsoft Office 365 ProPlus" and I haven't found any specific info about it online.
Oct 26 2021 05:26 AM
SolutionOffice 365 has become Microsoft 365 in April of 2020. If you have Office 365 ProPlus, it hasn't been updated for at least a year and a half. If you have a subscription, you should be able to update to Microsoft 365; you should then be able to use functions such as UNIQUE.
Oct 26 2021 03:39 PM
Oct 26 2021 05:26 AM
SolutionOffice 365 has become Microsoft 365 in April of 2020. If you have Office 365 ProPlus, it hasn't been updated for at least a year and a half. If you have a subscription, you should be able to update to Microsoft 365; you should then be able to use functions such as UNIQUE.