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?