Probably the A column (from Summary Sheet) contains some values. Try to clear the A3:A1000, if those values are not needed.
Why isn't dynamic array working? #SPILL!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 68%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERJ%3C/text%3E%3C/svg%3E)
Roz Jones
0
Reputation points
In a sheet called Summary Sheet, cell A2, i have this formula:
=IFERROR(UNIQUE(FILTER('Master Log'!B2:B1000, 'Master Log'!B2:B1000 <> "")), "")
In the Master Log sheet, when I enter a Name (column B), the first name appears, but when i add names below, I get #SPILL! How can i fix this?
I have no merged cells, neither sheet are tables (although that would be preferred)
Microsoft 365 and Office | Excel | For home | Windows
3 answers
Sort by: Most helpful
-
Viorel 123.6K Reputation points2025-08-10T17:56:36.4566667+00:00 -
Roz Jones 0 Reputation points
2025-08-10T20:53:34.6966667+00:00 It has the names of people
-
HansV 460.8K Reputation points MVP Volunteer Moderator2025-08-10T20:58:00.1433333+00:00 In that case, move the names to another column. The FILTER formula in A2 won't work correctly unless there are enough empty cells below A2. Alternatively, move the formula to a cell with lots of empty cells below it.
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 10%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
Jeronimo Fuerte 11,860 Reputation points Independent Advisor2025-08-10T21:32:40.88+00:00 Hi! Sorry to hear that you have troubles with this, #SPILL! almost always means the spill range is blocked.
- In Summary Sheet!A2, click the yellow warning icon next to #SPILL! > choose Select Obstructing Cells.
- Delete whatever it selects (values, formulas, even “empty” formulas that return "" count as NOT blank). Use Home > Clear > Clear Contents.
- Make sure A2 isn’t inside an Excel Table (structured tables don’t allow spilling). If it is, convert it back: Table Design > Convert to Range.
- Double-check there are no merged cells and that the formula has room to spill downward (A3 and below must be truly empty).
-
Roz Jones 0 Reputation points
2025-08-10T22:00:16.6666667+00:00 I have gone through all these column A in Master Log I enter the name of an individual and, in other columns, what they have done.
the summary sheet is to bring the information together
-
HansV 460.8K Reputation points MVP Volunteer Moderator
2025-08-10T22:27:26.68+00:00 You'll have to move the formula to a cell with enough empty cells below it!
Sign in to comment -