Excel Dynamic Arrays vs Google Sheets Arrayformulas: Fixing #SPILL! Excel throws #SPILL!, Google Sheets says the array ‘was not expanded.’ Same underlying problem, two different rules. Here’s how each one expands, why they block, and how to fix both.
