I'm wondering if anyone has a formula for ignoring blank cells in a data validation drop-down list that is referencing cells in columns.

This forum topic shows how to do it from data in rows, but my data is all in a column (and I don't want to have to transpose it every time I add a new cell):

http://www.excelforum.com/excel-gene...ml#post2400161

Post #3 has a great example worksheet. I need an equivalent formula that uses column data instead of rows.

As far as I'm aware, I can't use VBA code because I'm using Office 2008 for Mac.

Thanks.