Hello,

I have an Form Control drop down box, I want to add a dynamic range so it lists only a list of value > "" (greater than blank).

I've tried the various named range options i.e =OFFSET($A$1,0,0,COUNTA($A$1:$A$40),1) and a number of other methods using =EVALUATE(ie.NamedRange) but none of these work?!

My problem is, I have a range from 1-40 with formulas, where my formula result is "" (blank) I want my dynamic range to end so its could be A1:A12 where the formula returns "" in cell A13. The list is sorted using an array formula so that the first blank is in effect the last cell of the range - 1.

Does this make sense? How do I create the input range for this?