Offset On 2 Columns
 

I am using the following to name a range with 1 column, so it expands
dynamically. But how do I do this for 2 columns of data? Both columns will
have data filled in the exact same rows.

=OFFSET(Lists!$A$1,1,0,COUNTA(Lists!$A:$A)-1,1)

Offset On 2 Columns
 

=OFFSET(Lists!$A$1,1,0,COUNTA(Lists!$A:$A)-1,2)


--


Regards,


Peo Sjoblom




"Derek Hart" wrote in message
...
I am using the following to name a range with 1 column, so it expands
dynamically. But how do I do this for 2 columns of data? Both columns will
have data filled in the exact same rows.

=OFFSET(Lists!$A$1,1,0,COUNTA(Lists!$A:$A)-1,1)

Offset On 2 Columns
 

Am I missing something or not understanding. ,2 instead of ,1 for col a & b
based on length of col a.

=OFFSET(Lists!$A$1,1,0,COUNTA(Lists!$A:$A)-1,2)


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Derek Hart" wrote in message
...
I am using the following to name a range with 1 column, so it expands
dynamically. But how do I do this for 2 columns of data? Both columns will
have data filled in the exact same rows.

=OFFSET(Lists!$A$1,1,0,COUNTA(Lists!$A:$A)-1,1)