Dynamic Named Ranges across columns

[clumzyfish]

Hi All,

I have some data that spans over multiple columns and will continue to span over more rows in the same column.

I'd like to create a dynamic range based off these rows, lets say A:2 to A:20. Is it possible to do so with a formula that stops at the last blank cell? I've only been able to create ranges that span down a column instead of across.

This is the current formula I have, but it stops taking in cells once the last cell of a row (instead of column) is blank:

=OFFSET(Documents!$A$2,0,0,MATCH("*",Documents!$A$2:$A$1000,-1),1)

Thanks!

 

[Aladin Akyurek]

Hi All,

I have some data that spans over multiple columns and will continue to span over more rows in the same column.

I'd like to create a dynamic range based off these rows, lets say A:2 to A:20. Is it possible to do so with a formula that stops at the last blank cell? I've only been able to create ranges that span down a column instead of across.

This is the current formula I have, but it stops taking in cells once the last cell of a row (instead of column) is blank:

=OFFSET(Documents!$A$2,0,0,MATCH("*",Documents!$A$2:$A$1000,-1),1)

Thanks!

What do you have in column A - Text or numbers like dates, times, etc?

 

[clumzyfish]

all text values... ill have text values in the row below it, but i would like to not include those values in the range. just row A