Ignore blank cells and truly blank cells in named range?

Ok so my named range looks like this:

Please Login or Register  to view this content.

However, I want to ignore the "" cells and the truly blank cells... However, I think all of them will have "" since I have this formula in all of the ones I'm putting in the range:

Please Login or Register  to view this content.

How do I go about getting these results into a named range so I can use it on validation since validation only seems to ignore truly blank cells and not the "" ones.

@Tony, no... they are random because I'm doing something regarding databasing since the people messing with this spreadsheet won't know what the ID references stand for so I'm trying to put the column values in instead.
I want to use the non-blank columns for a data validation list, I just don't want it listing 40 random blanks until it gets to the next result that isn't blank.

First I'm grabbing two columns and concatenating them so they know the product group name and the product attribute that they are referencing. So all those columns contain a formula which will never be truly blank obviously.. the IF(ISBLANK())..

Is there anyway I can get past this?
Whether it's ignoring the blank values in a named range or ignoring the blank values in the data validation list?

I've tried doing everything listed in this forum:
http://www.ozgrid.com/forum/showthread.php?t=146990

But in my "new column" that is supposedly suppose to not list blank values or whatever, I get #REF errors regarding the FALSE columns even though it works for the other two people.

Answer: This helped solve my problem!

http://www.myonlinetraininghub.com/e...alidation-list