'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel SORT Function #NAME? Error on Mac
Question details
The user is encountering a #NAME? error when trying to organize data using the SORT function in Excel on a Mac.
- Product
- Microsoft Excel
- Device & OS
- Mac
- Scenario
- Attempting to dynamically sort a range or array of data using the SORT formula in a spreadsheet.
- Observed behavior
- The cell returns a #NAME? error instead of the sorted results, indicating that Excel does not recognize the function name.
Before troubleshooting your software version, double-check that you have spelled the SORT function correctly in the formula bar, as typos will also trigger a #NAME? error.
Check and Update Your Microsoft Excel Version
Verify if your current Excel installation supports dynamic array functions like SORT, and update the software if a newer version is available.
The SORT function is a dynamic array formula introduced in newer versions of Excel. It is natively supported in Microsoft 365 subscriptions and perpetual licenses starting from Excel 2021. Older standalone versions like Excel 2016 or 2019 do not support this feature.
Launch Microsoft Excel on your Mac. In the top menu bar, click on 'Excel' and select 'About Microsoft Excel' from the dropdown.
Look at the license information in the dialog box. Ensure it says 'Microsoft 365 Subscription' or 'Office 2021' (or newer).
If you have a supported license but are running an outdated build, click on 'Help' in the top menu bar and select 'Check for Updates' to install the latest patches.
Use the Built-in Data Sort Tool as an Alternative
If you cannot upgrade to a newer version of Excel, use the standard manual sorting feature available in all Excel versions.
Organize Spreadsheets Flawlessly with WPS Office
If you are restricted by unsupported functions and version incompatibility in older Microsoft Office software, consider switching to WPS Office. It is a powerful, free, and lightweight alternative that ensures seamless data management without expensive subscriptions.
- 1. Install WPS Office: Download and install the free WPS Office application for your Mac.
- 2. Open Your Workbook: Launch WPS Spreadsheet and easily open your existing Excel files.
- 3. Manage Data Easily: Utilize the extensive built-in tools under the Data tab to seamlessly sort and organize your information.
Frequently Asked Questions
Why does my SORT formula show a #NAME? error in Excel?
The #NAME? error occurs when Excel does not recognize the function name entered. This typically happens if the function is misspelled, or if you are using an older version of Excel that does not include the newer dynamic array functions.
Which versions of Excel for Mac support the SORT function?
The SORT function is supported exclusively in Microsoft 365 subscriptions and the standalone versions of Excel 2021 and newer. It is not available in Excel 2019, 2016, or older releases.
Can I add dynamic array functions to older versions of Excel?
No, dynamic array functions like SORT, FILTER, and UNIQUE are hardcoded into newer versions of the Excel computation engine. They cannot be downloaded as add-ins for older perpetual versions like Office 2019.
How can I sort data dynamically if I don't have Microsoft 365?
Without the SORT function, you can rely on the manual 'Sort' button found under the Data tab. Alternatively, you can use a complex combination of older functions (like INDEX, MATCH, and LARGE/SMALL) to mimic dynamic sorting, though this is heavily advanced and less efficient.
