Fix the Array result error

What Array result means

In Google Sheets, when a formula returns multiple values — such as UNIQUE, FILTER, or an ARRAYFORMULA — it attempts to write each value into its own adjacent cell. If any of those destination cells are already occupied by data or another formula, Sheets cannot expand the array and shows the 'Array result was not expanded because it would overwrite data in ...' error.

Common causes

• Another formula or value already exists in a cell where the array needs to spill its output.
• A cell in the expansion zone is blank but formatted with a space character or non-printing character that Sheets treats as occupied.
• The array formula itself is inside a cell that is part of a larger ARRAYFORMULA range, creating a collision.
• A merged cell occupies part of the spill area — Sheets cannot write into sub-cells of a merge.
• The filter or array produces more rows than expected and runs into data that was placed below assuming a fixed output size.

Example fix

The formula is correct. Clear the cells in the column below the formula cell where the results need to expand; the error disappears once the output zone is empty.

How to fix it

1. 1Click the error cell — Sheets highlights the blocking cell(s) in the error message. Clear those cells' content.
2. 2Move the array formula to an empty area of the sheet with no data to its right or below for the expected number of output rows.
3. 3Check for cells that appear empty but contain spaces: select them and press Delete (not Backspace) to ensure they are truly empty.
4. 4Unmerge any merged cells in the expansion zone: Format > Merge cells > Unmerge.
5. 5If the array is inside an ARRAYFORMULA that already handles an entire column, remove the outer ARRAYFORMULA and let the inner function (FILTER, UNIQUE) expand natively.

Frequently asked