Why SORT and FILTER Are Not Valid Excel Functions
Question details
The user needs to understand why Excel displays a function-not-valid error when using SORT and FILTER, and what versions or alternatives support these dynamic array functions.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user is building or opening a workbook that uses dynamic array formulas such as SORT and FILTER.
- Observed behavior
- Excel displays a function-not-valid error or does not recognize SORT and FILTER because these functions are not available in Excel 2019 and earlier versions.
Check your Excel version via File > Account > About Excel, and note the workbook file format if the file will be opened in different Excel versions.
Use Microsoft 365 or Excel 2021 to enable SORT and FILTER
Choose this if you need native dynamic array functions and can upgrade from Excel 2019 or an earlier version.
SORT and FILTER are dynamic array functions introduced in Excel for Microsoft 365 and Excel 2021. They are not recognized as valid functions in Excel 2019, Excel 2016, or earlier perpetual versions.
Open Excel, select File > Account, and check the version shown under Product Information.
Install Microsoft 365 or Excel 2021 from your Microsoft account, Microsoft Store, or your organization's software portal.
Open the target workbook, select a cell, type =SORT(array) or =FILTER(array,include), and press Enter to confirm that the formula is recognized.
Replace SORT and FILTER with Excel 2019-compatible alternatives
Choose this if you cannot upgrade and need the workbook to continue working in Excel 2019 or earlier.
Use WPS Office Free as a Lightweight Microsoft Excel Alternative for SORT and FILTER Workflows
If Excel 2019 does not recognize SORT and FILTER and an upgrade is not practical, WPS Office Free provides a familiar, lightweight spreadsheet environment. It opens Microsoft Excel files and offers sorting, filtering, and formula tools for a seamless migration without the cost of Microsoft 365.
- 1. Download WPS Office Free: Go to the WPS Office download page and install WPS Office on your Windows, macOS, Linux, or mobile device.
- 2. Open the Excel workbook: Launch WPS Spreadsheets, click Menu > Open, and open the .xlsx workbook you need to edit.
- 3. Continue with familiar spreadsheet tools: Use the Data tab for sorting and filtering or apply compatible formula alternatives in the WPS Spreadsheets interface.
Frequently Asked Questions
Why does Excel say SORT is not a valid function?
Because SORT is a dynamic array function available only in Microsoft 365 and Excel 2021 or later. Excel 2019 and earlier return a #NAME? or function-not-valid error.
Can I use FILTER in Excel 2019?
No, FILTER is not built into Excel 2019. You can upgrade to Microsoft 365 or Excel 2021, or use Advanced Filter, helper columns, INDEX, AGGREGATE, or VBA as alternatives.
What Excel versions support SORT and FILTER?
Excel for Microsoft 365 and Excel 2021 and later support SORT and FILTER natively. Excel 2019, Excel 2016, and earlier perpetual versions do not.
Is there a free alternative to Excel for SORT and FILTER tasks?
WPS Office Free is a lightweight Microsoft Office alternative that opens .xlsx files and provides familiar sorting and filtering features without requiring an Excel 365 subscription.
How do I check my Excel version?
In Excel, click File > Account. Your version is shown under Product Information, for example 'Microsoft 365' or 'Excel 2019'.
