Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    I am having trouble sorting a 10 column, 25 row selection on a worksheet based on certain criteris, where one or more of the columns contain formulas. When I copy special values the selection to another section ofd the worksheet, and then sort, it works fine. Any ideas?
    Thanks in advance.

  2. #2
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by jlkirk View Post
    I am having trouble sorting a 10 column, 25 row selection on a worksheet based on certain criteris, where one or more of the columns contain formulas. When I copy special values the selection to another section ofd the worksheet, and then sort, it works fine. Any ideas?
    Thanks in advance.
    The cells are sorting, but the because the formulae are using relative references they are returning the same values as before. If you make the formula references absolute thye will sort as you expect.

    Try sorting columns A and C on this sample. I've flagged 2 of the cells so you can see that the cells are sorting themselves, but the formulae are staying the same in the relative formulae[attachment=88099:sorting formulae.xls]
    Attached Files Attached Files

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Gfamily View Post
    The cells are sorting, but the because the formulae are using relative references they are returning the same values as before. If you make the formula references absolute thye will sort as you expect.

    Try sorting columns A and C on this sample. I've flagged 2 of the cells so you can see that the cells are sorting themselves, but the formulae are staying the same in the relative formulae[attachment=88099:sorting formulae.xls]
    Thanks.

Posting Permissions

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