TechSpot

Excel: Sorting with Formula

By Dataslycer
Sep 2, 2006
  1. I'm working with an excel document and I am having trouble with the sorting function since I have formulas within my data. Whe I use the sort function, the reference cell does not shift to the new position as it normally woud when you use copy or cut command. Is there a way to get around this?
     
  2. korrupt

    korrupt TS Rookie Posts: 716

    You sure youre sorting down and not across?

    Regards,

    Korrupt
     
  3. jobeard

    jobeard TS Ambassador Posts: 8,958   +587

    YEP! a real bummer! (my Office 2000 at least). seems like it would have been so obvious that this needed to work, but I've never got it right in several years now :(
     
  4. Dataslycer

    Dataslycer TS Rookie Topic Starter Posts: 31

    As far as I know. What I do is select the spreadsheet cells that contains data and click sort ascending. Here is the screenshot
     
Topic Status:
Not open for further replies.

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...