I have a worksheet for which I want to select an area which is 11 columns wide by a variable # rows. This variable # of rows depends on whether there is data - the first row that lacks data in column k should be omitted from my selection. The first or anchor cell at top left of selection is a13. The longest the list could be is to row 300.
My approach has been to attempt to define a name for this area - using this formula:
=offset(indirect("a13"),0,0,max(1,count(indirect("k13:k300"))),11).
This only selects the first row...what am I missing?
I then want to sort this list by a column, paste all this on a new page, and insert subtotals by the sort key. I think I can get most of that, but any suggestions would be most helpful!
My approach has been to attempt to define a name for this area - using this formula:
=offset(indirect("a13"),0,0,max(1,count(indirect("k13:k300"))),11).
This only selects the first row...what am I missing?
I then want to sort this list by a column, paste all this on a new page, and insert subtotals by the sort key. I think I can get most of that, but any suggestions would be most helpful!