title: Excel - my drop down list contains blanks
body: <p>Im populating a drop down list from a column on a separate sheet and unwanted blanks are showing up. The column contains the following formula:</p>
  
  <p>=IF(D2="Yes",B2,"")</p>
  
  <p>Excel is treating the result as an empty string and not blank. How do I remove the empty (and blank) values from my drop down list?</p>