Forum Discussion

FELIX_VILLA's avatar
FELIX_VILLA
Copper Contributor
Nov 13, 2022

Unique Function in Excel for Mac

The Unique Function is not available in my new MacBook Pro with chip Apple M1 Pro.

It was available in my old MacBook Pro with Intel Processor.

Anybody knows the reason?

Thank you.

3 Replies

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    What is your excel version? UNIQUE() is only availble to Microsoft-365 both for Windows as well as MAC.
    • FELIX_VILLA's avatar
      FELIX_VILLA
      Copper Contributor

      Harun24HR 

      My Excel version is Office 365, installed in two computers:

      1. My old MacBook Pro 2016 with Intel Processor.
      2. My new MacBook Pro 2021 with Chip Apple M1 Pro.

      UNIQUE() function (UNICOS() in spanish) is available only in my old computer, and it works properly. In my new computer that function is not available in the same Excel version.

      Perhaps it's necessary that Microsoft release an update for new Mac models.

      • FVA2022's avatar
        FVA2022
        Copper Contributor
        Now I have installed the last update of Office 365, and the UNIQUE() function is working properly.
        Thank you very much.

Resources