I’m trying to get my head around the detailed differences in Excel for Microsoft 365 vs 2021, particularly around function availability in each offering.
I understood that Excel 2021 included new functions such as UNIQUE, LET, XLOOKUP, SORT, FILTER, XMATCH, SORTBY, SEQUENCE, RANDARRAY etc. However I am running Excel 2021 for Mac and not all these functions are available. Can anyone confirm if they are available in Microsoft 365 Personal?
I am reluctant to move to the subscription model but may be tempted if these are available.
I have a 365 Subscription. I just looked and they are all there. I tested all that you listed. All worked like the following example. This is how I tested: I typed in =RANDARRAY and it show this:
Thanks! so seems like not all functions are ported to 2021 version. May have to just bite the bullet and subscribe. Looks like the cheapest way to do it is to buy a one year code from Amazon.