Offset On 2 Columns

  • Thread starter Thread starter Derek Hart
  • Start date Start date
D

Derek Hart

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)
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dependent drop down dynamic range formula, off sheet. 7
SUMPRODUCT - Tweak 2
Drop Down with dynamic named range offsheet source list 14
Offset code for dynamic row# & multiple columns in LINEST function 3
Dynamic Named Range formula without using OFFSET function 5
Dynamic Range & Offset code problem 3
Excel 2000 formula to dynamically sum adjacent rows and columns whererows inserted/deleted 2
Using offset in sumproduct, is it possible? 2

Back
Top