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...
That is Excel 2003-thinking.
Since Excel 2007 you can use Excel tables and structured references.
- 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 😕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?
