• Copy paste offset formula

    From David Cuthill@21:1/5 to All on Sun Aug 30 15:44:44 2020
    Hi another question ...

    I have the following formula located in cell AC3 ... =OFFSET($B$16,COLUMN()-29,1,1,1). If I copy this formula 3 columns over I would like to have the result be the value in B17. Currently it is stepping down 3 rows if I copy it to AF3.

    Thanks

    David

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)