• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. C

    Making the reference of an offset formula change when its dragged down

    Hi, need help with this formula To simplify imagine i have dates going from row B1 to L1 starting from 1-Jan-13 to 10-Jan-13 And on row 2 i have some numbers from B2 all the way to L On A3, i have dates again going down from 01-Jan-13 all the way to the 10th as well. On, B3, i have the...
  2. C

    How to insert a formula on the reference of an Offset Formula

    i have a combination of sum, offset and match formula which is working well for one row but i need it to move down, so the formula is something like this: =sum(offset($B$2,0,0,1,match($B$8,$B$8:$C$22))). This formula is on cell B9. Now, on B1 to E1 i have got dates starting from 1-Jan-13 and...
Back
Top