How to fix #SPILL! in Excel
What you see
- #SPILL! error
- Using FILTER, UNIQUE, or other dynamic arrays
Common causes
- Something blocks the cells below or to the right
- Merged cells in spill range
How to fix it
- Clear cells where results should spill
- Unmerge cells in the spill area
- Move the formula to a clear area