Excel troubleshooting

How to Fix #SPILL! in FILTER

Fix FILTER #SPILL! errors by clearing blocked spill ranges, checking merged cells, and understanding dynamic array behavior.

Problem

  • FILTER returns #SPILL! when Excel cannot place the dynamic array result into the cells below or beside the formula.

Quick fix

  • Clear the spill range, unmerge cells, and make sure the FILTER output has enough empty space to expand.

Why FILTER spills

  • FILTER can return multiple rows or columns, so Excel needs empty cells for the full result.
  • Blocked cells, merged cells, or tables can prevent the dynamic array from expanding.
  • The include argument must align with the filtered array.

Best fixes

  • Select the warning icon next to #SPILL! to see the blocked range.
  • Clear any values or formatting conflicts in the spill range.
  • Move the formula outside Excel Tables if the output needs to spill.

Frequently asked questions

  • Can I put FILTER inside a Table? Spill arrays conflict with Table structure. Place FILTER outside the Table or use structured references in a normal range.
  • What is the if_empty argument? Fourth argument in FILTER — return text like "No matches" instead of #CALC! when nothing matches.
  • FILTER vs UNIQUE for distinct values? UNIQUE returns distinct items; FILTER returns all rows that meet conditions. Combine them: =UNIQUE(FILTER(...)).