S
Sam
Hello everyone,
I've a question about dynamic ranges.
I can use something like this in a cell formula to create
a dynamic range reference -
INDIRECT("Sheet1!A$2:A$"&COUNTA(Sheet1!A:A))
If I want to create a dynamic named range and use it in
the formula instead, I use this -
Insert/Name/Define
Name - List
Refers to: =OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A:$A))
So my question is, aren't both of these formulas
interchangable? I always use the OFFSET function for named
ranges (I learned to do it that way).
What advantage does one have over the other? (other than a
few keystrokes)
Thanks
I've a question about dynamic ranges.
I can use something like this in a cell formula to create
a dynamic range reference -
INDIRECT("Sheet1!A$2:A$"&COUNTA(Sheet1!A:A))
If I want to create a dynamic named range and use it in
the formula instead, I use this -
Insert/Name/Define
Name - List
Refers to: =OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A:$A))
So my question is, aren't both of these formulas
interchangable? I always use the OFFSET function for named
ranges (I learned to do it that way).
What advantage does one have over the other? (other than a
few keystrokes)
Thanks