A
Arlen
I have a range called Labels1 that used to expand from A2 to A whatever.
Now, I have to change its functionality so that both the START and END can
change.
The old formula is this.
=OFFSET(Data!$A$2,1,0,COUNTIF(Data!$A:$A,">0"),1)
How do I change it so that $A$2 changes to a new start cell?
Thanks for your help.
Arlen
Now, I have to change its functionality so that both the START and END can
change.
The old formula is this.
=OFFSET(Data!$A$2,1,0,COUNTIF(Data!$A:$A,">0"),1)
How do I change it so that $A$2 changes to a new start cell?
Thanks for your help.
Arlen