Function Problems

Fix Missing FILTER and UNIQUE Functions in Excel

Emma BrownEmma Brown Nov 14, 2026 868 views

Question details

Find out why Excel FILTER and UNIQUE functions are available on one computer but not another with the same Microsoft 365 license.

Fix Missing FILTER and UNIQUE Functions in Excel
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.
Before you start

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.

Solution 1Recommended

Compare and Update the Excel Installations

Use this solution to check whether the affected computer has an older Excel build without dynamic array support.

1
Check both Excel versions

On each computer, open Excel and select File > Account > About Excel. Note the version and build numbers and compare them.

2
Compare update channels

On File > Account, check the Product Information area for the update channel, if shown. Different channels can receive features and updates at different times.

3
Update the affected computer

On the computer missing the functions, select File > Account > Update Options > Update Now. Install available updates and restart Excel.

4
Test the workbook

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.

Compare and Update the Excel Installations
Updates may be managed: If Update Options is unavailable or updates are controlled by your organization, contact your IT administrator. Sharing the version, build, and channel from both computers can help them identify the difference.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX filesUse a familiar spreadsheet interface for workbook tasksTry a free, lightweight alternative to Microsoft OfficeCheck how your workbook's dynamic array formulas behave in WPS Spreadsheets
microsoft office alternative - wps office

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.