Hi All,
I have attached a reference workbook.
In it I have tried to define a dynamic named range called "data".
I want it to extend dynamically across and down from Cell A10. With the given data, I have used the formula, in the data worksheet:
Even though rows L, M and N are empty, the dynamic range actually goes out to column Y.=OFFSET(data!$A$10,0,0,COUNTA(data!$A$10:$A$65536),COUNTA(data!$10:$10))
Could anyone please explain why the above formula is not stopping at Column L in this case ? (please note there may be data in cols M, N etc, so I would like the formula to extend dynamically across).
regards?