Dynamic dropdown list quandry

[Shocked]

I have a workbook with 2 tabs, one for products and the other is a form.

I want to use a dynamic dropdown list which I know how to create.

The problem that I have is that I have additional data regarding products below the dynamic name range and my dropdown is picking these up.

For example:

I have a range named alternate name and it resides in C66: C84.
If I used the standard =offset(product!$c66,0,0,counta(product!c:c),1) I get my desired list plus everything in that column below my desired list.

If I use count, the dropdown does nothing.

any ideas?

[protonLeah]

Replace "product!c:c" with "product!c1:c65"

[sglife]

Change product!c:c to your range name , "alternate_name"

[Shocked]

hey thanks guys. I went with the c:c to c1:c65 but this isn't really dynamic, it works though.

I wasn't aware the c:c to alt_name was an option. I'll look into it a bit further.

[mikerickson]

Its not clear to me what data you want to return
You have a range "alt_name" that starts at C66 and goes past the end of the column C data. (assuming no blank rows in C)
Do you want the dropdown to be populated with

1)the data above C66, then use =OFFSET(D1,0,0, COUNTA(D1:D65), 1)

2)only the data in below C65, use =OFFSET(D66,0,0, COUNTA(D:D)-COUNTA(D1:D65), 1)

3)something else?