title: Excel searchable data validation dropdown lists
body: <p>There are two ways to make drop down list in Excel:</p>
  
  <ol>
  <li>Data validation list</li>
  <li>Combobox form control</li>
  </ol>
  
  <p>Now in my project I have Data validation dropdown lists wich can be too long and I want to add search functionality for it. I've find some solutions but only for combobox control, which not applicable for my Excel document, because theese dropdown lists should be repeated in each row:</p>
  
  <p><img src="https://i.stack.imgur.com/rLgYG.jpg" alt="enter image description here"></p>
  
  <p>Is there any possible solution to add search functionality to datavalidation dropdown list?</p>