Fix Missing FILTER and UNIQUE Functions in Excel
Question details
Find out why Excel FILTER and UNIQUE functions are available on one computer but not another with the same Microsoft 365 license.

- Product
- Microsoft Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- The user wants to use the same workbook and dynamic array formulas on both computers.
- Observed behavior
- FILTER and UNIQUE work on one computer but are unavailable on the other.
Open Excel on both computers and have the workbook available for testing. Check that both installations are signed in with the account associated with the Microsoft 365 license.
Compare and Update the Excel Installations
Use this solution to check whether the affected computer has an older Excel build without dynamic array support.
On each computer, open Excel and select File > Account > About Excel. Note the version and build numbers and compare them.
On File > Account, check the Product Information area for the update channel, if shown. Different channels can receive features and updates at different times.
On the computer missing the functions, select File > Account > Update Options > Update Now. Install available updates and restart Excel.
Reopen the workbook and test a FILTER or UNIQUE formula in an empty area. If the functions are still unavailable, compare the updated version and channel with the working computer.

Check the Microsoft 365 Update Channel
Use this solution if updating does not make the functions available or the two computers use different update channels.
Work with Excel Files in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Excel file compatibility for an easier transition. It does not update or repair Microsoft Excel; check formula compatibility in WPS Spreadsheets before relying on the workbook.

Frequently Asked Questions
Why are FILTER and UNIQUE missing if both computers use the same Microsoft 365 license?
The computers may have different Excel versions, builds, or update channels. Compare them under File > Account and About Excel.
How do I update Excel on the affected computer?
In Excel, select File > Account > Update Options > Update Now, then restart Excel. If that option is unavailable, your organization may manage updates.
What does an _xlfn prefix in a formula mean?
It can indicate that the Excel installation does not recognize a function in the workbook. Check the version under File > Account > About Excel and install available updates.
Can I change the Excel update channel myself?
It depends on how Office was installed and managed. If your organization controls updates, ask its IT administrator to review the channel and deployment settings.




