Forum Discussion
formula help
I need some help figuring out this spill error. I'm trying to take the information from column 2, column 15, and column 16 when column 18 does not have an x and automatically populate that informatio...
The error usually means Excel is trying to return multiple rows/columns, but something is blocking the output range (non‑empty cells, merged cells, or a table structure). To fix this, you may try to:
1. Clear the output area: Delete any values, formatting, or merged cells below/next to your formula cell.
2. Move formula outside a Table: Place it in a normal range, not inside an Excel Table.
3. Use CHOOSECOLS (Excel 365/2021) or, if not available, wrap with {} indexing like you attempted.
4. Test condition separately: Try =FILTER(Roster, Roster[Column18]<>"x") first to confirm it returns rows, then add column selection.