Ignore blank cells created by formula

**Versial** · 02-14-2013, 09:47 PM

I have been trying to get around this for a couple days now. Ultimately I want a Dropbox from a range, but the range is filled with formula that return names or blank values. Data validation's "Ignore blank cells" doesn't work with this because the cells are not technically blank, they just return blank. ISTEXT returns all the cells as TRUE even if empty.

**vlady** · 02-14-2013, 10:10 PM

you could try to look at this one.

http://www.excelforum.com/excel-gene...down-list.html

**Versial** · 02-14-2013, 11:13 PM

Thank you very much I was able to implement that.

**vlady** · 02-14-2013, 11:20 PM

Your very much welcome. If you don't have any further concern can you mark this thread "Solved", thanks.

How?
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Note:
You can also thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given.
By doing so you can add to the reputation(s) of those who helped and shared their time in helping you.