Fix an error
Fix the #CALC! error
What to do
- #CALC! usually means a formula such as FILTER found nothing to return.
- Add a third item to FILTER to show a message, such as "No matches".
Good to know
- Check the test in the formula if you expected results.
The idea in general
The result is empty, and Excel has no way to show an empty list.
What I assumed
- You are using Excel on a computer. Menus can look a little different on a Mac or in a browser.