Microsoft Excel — Hard
Key points
- Dynamic array formulas require a clear spill range
- Non-empty cells can block the spill area
- Merged cells can also obstruct the spill range
- Resolving the error requires adjusting the surrounding cells
Ready to go further?
Related questions