Data Validation & Named Range

I have the following data validation set up on my department names list. This works to block any blank or duplicate entries.

=AND(COUNTIF($A$2:$A$100,A3)=1,COUNTA($A$2:$A2)=ROW()-2)

I also have a dynamic named range on the same list:

=OFFSET('Validation Named Range'!$A$2,0,0,MATCH("*",'Validation Named Range'!$A:$A,-1),1)

When I access my named range via a combo box it allows me to select a blank cell (Which I don't want). I want it to only allow for those names in my name range.

Is this possible?

Thanks WinteE

I checked our your site and it had a lot of great information. However I wasn't able to find a solution to my problem.

How can I stop the last blank entry in a list box while using a Dynamic Range?

Dylan:

If your concern is the LAST entry in the data validation drop down being a blank, just modify your dynamic range formula as such:

=OFFSET('Validation Named Range'!$A$2,0,0,MATCH("*",'Validation Named Range'!$A:$A,-1)-1,1)

Report back if that works.

Works great BigBas. Thanks!