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...
It sounds like your formulas may be spilling?
For example, if I create a 5x5 matrix with SEQUENCE, I can produce the same error when attempting to table it:
The issue Excel has is tables, for all their conveniences, are scalar based (1 formula goes in 1 cell producing 1 result).