Dynamic named ranges - anything above zero

ryantaylor

New Member
Joined
Jan 7, 2011
Messages
4
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
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

scottylad2

Well-known Member
Joined
Feb 2, 2009
Messages
1,919
Is there likely to be a 0 in the middle of the expanding columns? if so what would you like to show?
 

ryantaylor

New Member
Joined
Jan 7, 2011
Messages
4
No, there will never be a zero in the middle of the range. The data will raise above zero in a sequential manner.
 

scottylad2

Well-known Member
Joined
Feb 2, 2009
Messages
1,919
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,753
Messages
5,524,664
Members
409,597
Latest member
Dannydev

This Week's Hot Topics

Top