• 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. A

    Sorting messes up relative address in formula

    The odd thing is that I usually remove the sheet name (if the formula is on the same sheet) simply to reduce the No. of characters in the formula!
  2. A

    Sorting messes up relative address in formula

    Hi. Thanks for the replies. The formula is on the 'New Main' sheet. That link looks like it, Luke. I created the formula using the mouse (so clicked over onto the 'Ledger' file for the first variable, then back to the 'New Main' sheet to pick up A2. I wonder if that's what caused it...
  3. A

    Sorting messes up relative address in formula

    Hello. I've got this formula in Row 2: =SUMIF(Ledger!$E$4:$E$1333,'New Main'!A2,Ledger!$AP$4:$AP$1333) I always build up and check my row formulae first, then simply copy them down to the last row on the sheet. At some point I sorted the spreadsheet, and somehow although many rows had the...
Back
Top