Share via

Excel Build 16.59 on MAC / Dynamic Array functions

Anonymous
2022-03-25T06:24:38+00:00

I installed the Home-Student Version of Office 2021 for MAC.

Looking at the Excel version, it is Build 16.59.

Although I have some of the newer functions, such as LET and xlookup, I don't have SEQUENCE or UNIQUE or those dynamic arrays.

I thought Excel 2021 would have those functions?

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2022-03-25T16:03:10+00:00

    Hi

    I think you need a subscription license, not a permanent license, to be able to use these new formulas.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-03-25T07:16:01+00:00

    Hi SubET_DZ, hope you're doing well. I’m Ian, and I’m happy to help you today.

    You are correct, these functionalities should be available in Excel 2021.

    You can try to do the reinstallation of your Microsoft Office

    If problem persist, go to this link https://account.microsoft.com/ and login your account. In that site, click the Feedback button on the lower left of the screen then report this problem.

    Btw, what happened when you used the SEQUENCE or UNIQUE functions? Do you received an error?

    This is a user-to-user support forum and I am a fellow user.

    I hope this helps, but please let me know if you need anything else.

    Was this answer helpful?

    0 comments