Ok so my named range looks like this:
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.Please Login or Register to view this content.
Bookmarks