• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Drop down list Blank cells [SOLVED]

bobhc

Excel Ninja
Good day PMMAN


Firstly welcome to the forum please read the green sticky's they will help you in the use of the forum.


As to your question:-


Do not put them there in the first place :)


No but seriously have you checked the range where you are pulling the data validation from to check for blank cells?


Good idea to do as srinidhi has suggested as well but no point in pulling blank cells in the first place
 

NARAYANK991

Excel Ninja
Hi ,


There are any number of links on this ; check this :


http://www.myonlinetraininghub.com/excel-ignore-blanks-in-data-validation-list


Narayan
 
Top