Hi,
I have a formula, which contains the formula component "Row($1:$50)". When I insert a new row at the top of the sheet, the reference becomes "Row($2:$51)" which messes-up my formula. Is there a Non-Volatile way to maintain the $1:$50 if I insert a row at the top of the sheet? Would rather not use Indirect or other Volatile functions.
Thanks!
I have a formula, which contains the formula component "Row($1:$50)". When I insert a new row at the top of the sheet, the reference becomes "Row($2:$51)" which messes-up my formula. Is there a Non-Volatile way to maintain the $1:$50 if I insert a row at the top of the sheet? Would rather not use Indirect or other Volatile functions.
Thanks!