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.


    =OFFSET(B10,-6,-7)

    =OFFSET(B10,-7,-7)

    =OFFSET(B10,-8,-7)

    =OFFSET(B10,-9,-7)

    =OFFSET(B10,-10,-7)

    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!

    Love 3

Participate now!

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

Register Yourself Login