excel formula help neede

Discussion in 'OT Technology' started by Jaybob, Feb 14, 2006.

  1. Jaybob

    Jaybob New Member

    Joined:
    Oct 14, 2005
    Messages:
    5
    Likes Received:
    0
    When I sort two columns (one with a formula) excel changes the formula. It assumes that since the info was moved down three cells that I want the formula moved down three cells also. i.e. =a1+a2 it gets sorted and goes down two cells. It now reads =a3+a4. How do I tell excel to just leave the formula how I typed it and not assume I want it changed. Thanks
     
  2. mobbarley

    mobbarley Active Member

    Joined:
    Mar 4, 2005
    Messages:
    9,256
    Likes Received:
    2
    Location:
    Sydney
    Ive never tried that, but try sorting with the formula column also selected.

    Other than that try cutting the column, sorting, then pasting?

    Just some ideas.
     
  3. dorkultra

    dorkultra OT's resident crohns dude with an ileostomy bag OT Supporter

    Joined:
    Oct 14, 2005
    Messages:
    23,240
    Likes Received:
    110
    Location:
    yinzer / nilbog, trollhio
    use absolute referncing. if you want to absolute refence a cell, ex: A3...use A$3$.

    and buy a sub
     

Share This Page