Dynamic named ranges - anything above zero

[ryantaylor]

Hi,

Is it possible to set up a dynamic range that expands across a number of columns when the data in those columns increases above zero?

Thanks

 

[scottylad2]

Is there likely to be a 0 in the middle of the expanding columns? if so what would you like to show?

 

[ryantaylor]

No, there will never be a zero in the middle of the range. The data will raise above zero in a sequential manner.

 

[scottylad2]

Ok, say your range goes from Col A try this, =A1:Index(A1:X1,1,Counta(A1:X1)) as you add data into B1, C1 etc your range will expand. I've only taken it to X1, make the expanse much bigger than you're ever likely to need