I have a drop down list in EXCEL 2007 that includes the values from a range
that contains 8000 cells. Each one of these cells contains a formula. This
worksheet is a template that could at times use all 8000 cells, but usually
many of them will be blank. The problem is, since they include functions,
they aren't actually empty, they just output "". This makes the dropdown
list very long which makes it difficult to find values in it. How do I fix
this problem?