Forum Discussion
Unwanted change of the formula when increasing the table
Artik_K , that's a normal behaviour. Excel remembers what $B3 is in the last row of the table, and when you expand the table it automatically substitutes the reference on the cell in the new last row.
In general with tables it's better to use structured references, in your case like
=COUNTBLANK(INDEX([B],1):[@B])
Artik_K , that's a normal behaviour. Excel remembers what $B3 is in the last row of the table, and when you expand the table it automatically substitutes the reference on the cell in the new last row.
In general with tables it's better to use structured references, in your case like
=COUNTBLANK(INDEX([B],1):[@B])
SergeiBaklan wrote:Artik_K , that's a normal behaviour.
As for me, this is not normal behavior. Excel destroyed my formula. The more so because in XL2007 there was no problem.
However, I really like the solution from INDEX ().
Thank you.
Artik
Artik_K , yes, I took wrong word. I mean that's by design.
