Forum Discussion
Referencing all non-blank values in a row/column
Hello Microsoft Community, I've been building up a large worksheet that has several sheets using functions such as XLOOKUP & VLOOKUP from a series of tables. I expect to use this sheet for severa...
Hey Detlef, thanks for the answer.
The issue with Tables is that they don't allow to have formulas inside of them; I always get #SPILL errors if I try to change my data to Tables 😕
The issue with Tables is that they don't allow to have formulas inside of them; I always get #SPILL errors if I try to change my data to Tables 😕
Depends on how you build the formula. In structured tables that is per-row reference, formula is automatically populated on entire table.
- Hey Sergei, not sure I understand; what do you mean by a structured table with a per-row reference? when I've tried mixing tables and references I've always gotten a spill error; is this a different type of table?
- I see! I always attempted the first instance, let me try the second and see if it works.
Thanks Sergei!