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 information into employees staying late what rf gun they have and what temp probe they have. it is showing me a spill error and i can't figure how to fix it. I'm still new and learning. i also provided the formula that i currently have in that cell.
2 Replies
Can you please attach a sample file or share via OneDrive, Google-Drive, Dropbox or similar service so that we can check your data structure and type and suggest best formula for you?
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.
