Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Sorting Problem

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Larry
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    When I try to "sort" by 2 different (number formatted) columns the top 3 numbers are not in the correct order. I have tried changing the formatting Category, but it still does the same thing. I have checked for spaces and odd characters.

    HELP!
    _________________
    Larry

    [ This Message was edited by: twoone on 2002-04-11 08:36 ]

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-11 08:35, twoone wrote:
    When I try to "sort" by 2 different (number formatted) columns the top 3 numbers are not in the correct order. I have tried changing the formatting Category, but it still does the same thing. I have checked for spaces and odd characters.

    HELP!
    _________________
    Larry

    [ This Message was edited by: twoone on 2002-04-11 08:36 ]
    what are the top three numbers? do you have field names?
    "Have a good time......all the time"
    Ian Mac

  3. #3
    New Member
    Join Date
    Apr 2002
    Location
    Larry
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    They are titled as below. This is "Item #" column that will not sort (top 3).
    The "Shift" column is all "1"
    SHIFT
    1

    ITEM #
    411105
    411172
    411288
    411010
    411014
    411034
    411036
    411038
    411044
    411045


  4. #4
    Board Regular
    Join Date
    Apr 2002
    Location
    N.E. Ohio
    Posts
    236
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    in another field, multiply the field by 1 and sort on that. I have hade this problem before and it was usually due to a "space" before or after the number.

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-11 08:46, twoone wrote:
    They are titled as below. This is "Item #" column that will not sort (top 3).
    The "Shift" column is all "1"
    SHIFT
    1

    ITEM #
    411105
    411172
    411288
    411010
    411014
    411034
    411036
    411038
    411044
    411045

    Could you do us this favour:

    in a separate cell put = then
    select an area that you have a problem with, so it say somthing like =A1:B40.

    hit F9 and copy/paste the results here.
    "Have a good time......all the time"
    Ian Mac

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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