Ignoring Blank value in a drop down list

[Leo Heuser]

Hi Shail

I'm sorry, but I don't know, when I'll be finishing
the new formula, so don't spoil your nights sitting
and waiting for it <bg>

To get some information about array formulae, try
this article by Bob Umlas:

http://www.emailoffice.com/excel/arrays-bobumlas.html

 

[shail]

Hi Leo,

Thanks for the post. Yes, I have been waiting for the new formula by
you everyday. Also trying to get how the formula posted by you is
working (and literally, I am scratching my hairs.. hahaha)

Thanks again.

Shail