Hi. I am trying to create a drop down list that automatically excludes blank cells.

For Excel 2010, the following works no problem when included in the Define Name window:

=formula!$U$2:INDEX($U$2:$U$60,COUNTIF($U$2:$U$60,"?*")

However, in Excel 2007, the same formula does not work. For more information on how I am getting here: http://www.youtube.com/watch?v=6PcF04bTSOM

Go to the 18:30 mark.

Thank you,