Dependent drop down lists- dynamic data range- excluding Headers

**strud** · 05-23-2013, 07:06 AM

I have been using the contextures guide to creating dependent drop lists based on dynamic data ranges

(scroll to the bottom of: http://www.contextures.com/xlDataVal02.html)

However I am having trouble being making it work with headings at the top of the dynamic data columns- OFFSET always returns a blank row at he end of the range or the drop down list fails.

Anybody got any idea how to change the contextures guide formulas so as to be able to put headings above the dynamic data??

Thanks in advance..

Strud

**:) Sixthsense :)** · 05-23-2013, 07:18 AM

Please attach a sample workbook with expected output for giving exact solution

**ratcat** · 05-23-2013, 07:32 AM

G'day

My 2 cents worth is that you'll have to adjust your rows offset. Noted in red in example below and/or adjust your Counta starting position.

=OFFSET(Lists!$D$1,0,0,COUNTA(Lists!$D1:$D100),1)

**strud** · 05-28-2013, 04:10 AM

Originally Posted by ratcat

G'day

My 2 cents worth is that you'll have to adjust your rows offset. Noted in red in example below and/or adjust your Counta starting position.

=OFFSET(Lists!$D$1,0,0,COUNTA(Lists!$D1:$D100),1)

Apologies for the delay in getting back to you..but thanks ratcat that got it!

Thanks for your help!