Remove blank in drop list

Good Day;

how to remove the blank list in drop list?


https://www.dropbox.com/s/k6m1x2azok...mple.xlsx?dl=0

thanks a lot

1. Created a new Sheet3
2. In cells A1:A4 entered list of four schools
3. In Name Manager, defined list with Name "List"
4. In Data Validation, changed look up to the defined "List"

See attached.

I not good in excel, please give me the sample formula?

https://www.dropbox.com/s/hy8jqbbe0x...heet.xlsx?dl=0

crossposted: droplist