Forum Discussion
Are Dynamic Array Functions not Available to Microsoft 365 Mac Users?
Maybe uninstall Excel and re-install. That's the only thing I could think of. Do you have just the one Mac under your subscription?
(I'm spoiled; have an older MacBook Air as well as the M1 Mini, both up-to-date with the same OS and current versions of Excel; and both have all the Dynamic Array functions. But if you were to have another Mac under your subscription, it would certainly warrant checking to see whether the other one does have access to those functions.)
Thanks Mathetes.
Very puzzling. When I open your spreadsheet, I see the Legacy functions "_xlfn._xlws.SORT", etc. Furthermore, when I search the available formulas, I don't see any of the Dynamic Array Functions.
Maybe uninstall Excel and re-install. That's the only thing I could think of. Do you have just the one Mac under your subscription?
(I'm spoiled; have an older MacBook Air as well as the M1 Mini, both up-to-date with the same OS and current versions of Excel; and both have all the Dynamic Array functions. But if you were to have another Mac under your subscription, it would certainly warrant checking to see whether the other one does have access to those functions.)
- mathetes, that did the trick. Thank you so much for helping me out. You are a scholar and a gentleman!
- You're very welcome. I'm so glad it worked. Always great to help a fellow M1 Mini user.