Forum Discussion
New formulas like FILTER and UNIQUE not appearing on macOS
Hello, I have MacBook pro with macOS Monterey 12.6.6 and I am running Excel 365 16.82. I know there is a more recent version of macOS and Excel which requires 13.0 or newer, but I don't think my vers...
Make Sure Excel is Fully Updated
You're on 16.82, which is relatively recent, but an update might be required for dynamic arrays.
Check for updates:
Open Excel.
Click Help > Check for Updates.
Run Microsoft AutoUpdate and install any available updates.
If not works…
macOS Version May Be a Limitation
You’re on macOS Monterey (12.6.6), and Microsoft does state that some newer Excel features require macOS 13 or later.
If you can, update to macOS 13 or 14 and check if that enables the missing functions.
My answers are voluntary and without guarantee!
Hope this will help you.