Forum Discussion
Solved
Excel 2013 table wrong formula extension with 'mask'
Dear all, just experienced some strange habit in Excel, version 2013. I've created a table with some columns, the first for numbering. The table starts in cell B6 with headline, subsequent data entr...
Hi,
With the table try to use (if "b" is the name of the column)
=ROWS(B$7:[@b])*(LEN(C7 & D7)>0)
to take the rows between first one and the current. Or even better
=ROWS(B$7:[@b])*(LEN([@c] & [@d])>0)
With autoexpanding of the table initial B7 is interpreted as the last row in the table and substituted accordingly
