Data Validation List with only non-blank cells

It looks like your issue was resolved, so I hope you don't mind if I hyjack your thread since my issue is similar to yours.

I am using the equation mentioned, and I also have a long list of "blank" cells (they actually have equations in them that will fill in the cell when applicable). My new dropdown validation list recognizes the 2 cells that are not blank, however it shows 2 blank spots, instead of two actual items from my list. Did I make a mistake somewhere?