How to Fix Missing SEQUENCE and UNIQUE Functions in Excel 2021 for Mac
Question details
The user is unable to locate or use the SEQUENCE and UNIQUE dynamic array functions in Excel 2021 for Mac, even though other modern functions like LET and XLOOKUP are available.
- Product
- Microsoft Excel 2021 for Mac
- Device & OS
- Mac
- Scenario
- Attempting to build dynamic array formulas to organize and extract data streams within spreadsheets.
- Observed behavior
- The SEQUENCE and UNIQUE functions return a #NAME? error or do not appear in the formula autocomplete list, despite Excel 2021 being officially capable of supporting them.
Ensure that your Mac is connected to the internet to verify your Microsoft account license and confirm that you are not accidentally opening the file in an older, cached version of Excel.
Update or Reinstall Excel for Mac
Applying the latest software updates or performing a clean installation ensures that all dynamic array features are properly loaded.
While Excel 2021 includes SEQUENCE and UNIQUE natively, specific build versions might experience feature rollout glitches. Forcing an update or reinstalling the suite typically restores missing function libraries.
Open Excel for Mac, navigate to the top menu, and select 'Help' > 'Check for Updates'. Install any pending updates.
Restart Excel, open a blank workbook, and type '=UNIQUE(' in a cell to see if the function is now recognized.
If the functions are still missing, close Excel, go to your Mac's 'Applications' folder, and move Microsoft Excel to the Trash.
Log in to account.microsoft.com, download the latest Office 2021 for Mac installer, and complete the installation process.
Verify Your Excel License Type
Check if an older perpetual license (like Office 2019) is conflicting with your Office 2021 installation on your Mac.
Submit Feedback to Microsoft Support
Report the persistent missing function issue directly to the Microsoft development team.
Use SEQUENCE and UNIQUE Functions Smoothly in WPS Office
If you are tired of troubleshooting missing features or license conflicts on your Mac, WPS Office offers a powerful, seamless alternative. WPS Spreadsheet natively supports modern dynamic array functions like SEQUENCE, UNIQUE, and XLOOKUP, allowing you to manage and analyze your data instantly without expensive subscriptions or complicated updates.
- 1. Download and install WPS Office: Get the free WPS Office suite for Mac from the official website and install it.
- 2. Open your workbook: Launch WPS Spreadsheet and open your existing .xlsx file containing your data.
- 3. Enter the dynamic formula: Select an empty cell and type =UNIQUE(A2:A20) or =SEQUENCE(5,5) depending on your needs.
- 4. Press Enter to spill: Hit Enter, and WPS Spreadsheet will instantly calculate and spill the dynamic array results perfectly.
Frequently Asked Questions
Why do dynamic array functions return a #NAME? error?
The #NAME? error indicates that Excel does not recognize the function name. This typically happens if the function is misspelled, or if your current version of Excel does not support dynamic array functions like SEQUENCE and UNIQUE.
Are SEQUENCE and UNIQUE functions available in Excel 2019?
No. Dynamic array functions were introduced exclusively for Microsoft 365 subscribers and subsequently added to the perpetual Excel 2021 version. Excel 2019 does not support them.
Does WPS Office support dynamic array formulas?
Yes, recent versions of WPS Spreadsheet fully support dynamic array formulas, including UNIQUE, FILTER, SORT, and SEQUENCE, providing excellent compatibility with modern Excel workbooks.
How can I tell if my Office 2021 for Mac is updated?
You can check your version by opening Excel, clicking on 'Excel' in the top menu bar, and choosing 'About Microsoft Excel'. You can verify if you are on the latest build by using the 'Check for Updates' tool in the Help menu.
