creating dynamic range with offset

Hi all,

How can I create a dynamic range with an offset function if the range the formula is referring to has no actual "blanks", but rather formulas where some cells return a "". For all my other dynamic ranges I used:

Please Login or Register  to view this content.

But since COUNTA counts only real blanks not cells with formulas returning "", it won't work for such a case.

Is there a workaround? maybe with a LEN>1, as all other cells have a least 2 characters? Something like the below?

Please Login or Register  to view this content.

Don't seem to get it to work...

Yup. That works, easier than I thought. Thanks!