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:

=OFFSET(Control!$Q$6,0,0,COUNTIF(Control!$Q$6:$Q$15),1)
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?

=OFFSET(Control!$Q$6,0,0,COUNTIF(Control!$Q$6:$Q$15,LEN($Q$6:$Q$15)>1),1)
Don't seem to get it to work...