Offset incremental row increase away from anchor row

  • Hi Folks,

    For the offset formula below that I copied multiple times downward in a column, is there any way I can write the row number increase as a formula? Any help would be appreciated. Thanks.






  • You can use ROW(A6)*-1 copied down (assuming starting at -6) or ROWS($A$1:$A6)*-1

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!