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.
Bookmarks