Results 1 to 2 of 2

Thread: copy formula horizontally

  1. #1

    copy formula horizontally



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,
    I am stuck in copying formula horizontally, here what I want to do
    This is base file
    year 2015 tast1 tast2
    10000 .2 .6
    50000 .9 .1
    40000 .5 .5


    I want to create a file like this
    dept1
    tast1 sumproduct of year 2015 and task1
    task2 sumproduct of year 2015 and task 2


    So here year range will remain constant but column will change. I am not able to do it .
    It would be a big help for me.

    Regards,

  2. #2
    Try

    =INDEX($B$1:$C$1,1,MOD(ROW(A2),2)+1)

    and

    =INDEX(A:A,INT(ROW(A2)/2)+1)*INDEX(B:C,INT(ROW(A2)/2)+1,MOD(ROW(A2),2)+1)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •