Forum Discussion
Spill Error with named ranges on a table
It depends on concrete situation - are Hours and Rate named ranges or columns within the table or, as variant, named cells. In any case you cant use formula which return the spill within the table, only outside it and if there is enough space for the spill. Within the table second formula is correct, it returns result for the current row.
SergeiBaklan Hours and Rate are named ranges
If named ranges when you shall use =Hours*Rate outside the table.
SergeiBaklan so you cannot use named ranges in the table?
was it the case that you could use named ranges in a table before and not get the spill error, I am just wondering as the tutorial used the named ranges in the table and it is not possible to do this now.
thanks for your help
Nope, you can't use them within the tables for the Excel which support dynamic arrays. Perhaps tutorial is bit outdated and for previous Excel versions.