I am having the same problem. I need to remove blank cells from a drop down list. The cells become blank when the formula =IF($G$2=A3,A3,"") tells it show no data.
Is there away of drop down list not desplaying blank cells with out haveing to change the range selected.
<table style="border-collapse: collapse; width: 77pt;" border="0" cellpadding="0" cellspacing="0" width="103"><tr style="height: 15pt;" height="20"><td style="height: 15pt; width: 77pt;" width="103" height="20">
</td> </tr></table>