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?