Remove blank in drop list

[kurtmarlon]

Good Day;

how to remove the blank list in drop list?


https://www.dropbox.com/s/k6m1x2azokc87jq/sample.xlsx?dl=0

thanks a lot

[alansidman]

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.

[kurtmarlon]

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

https://www.dropbox.com/s/hy8jqbbe0x7stjv/sheet.xlsx?dl=0

[alansidman]

crossposted: droplist (http://www.excelforum.com/excel-charting-and-pivots/1078360-droplist.html)