Forum Discussion
Using formulas in a table
Hi there Is anyone able to assist me with the below issue: We currently have an excel response sheet from a microsoft form. The first tab collects all the responses in their necessary categor...
Thank you for the response. Yes, sometimes we do get the spill error.
We tried creating a table out of the cells before inputting the formulas and that's when we get the spill error or it just results in "0".
Is there any solution for getting your resulting data into a table format without creating static text because we need these tables to update automatically.
You'd have to choose between using dynamic array formulas that spill or using a table with lookup formulas that do not spill. A function like FILTER, for example, cannot return a spill within a table.
- Thank Patrick 🙂
We were originally using the filter function but that doesn't work in table format. We can call data from a table but cannot put the resulting data in a table