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

Thread: Sorting in Excel

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Ahmedabad Gujarat
    Posts
    303
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have written down following in excel row...

    Sheet1
    sheet3
    sheet2
    sheet10
    sheet11
    sheet12


    now when i give sort command from excel .. excel sorts the items in following way...

    sheet1
    sheet10
    sheet11
    sheet12
    sheet2
    sheet3


    I have written all charactes in lower case.

    Actually the sorting should be in

    sheet1
    sheet2
    sheet3
    sheet10
    sheet11
    sheet12
    sheet13


    how should i overcome this problem

    ni****h desai

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Then you need to name them that way:

    sheet01
    sheet02
    sheet03
    sheet10
    sheet99

    sheet001
    sheet101
    sheet358
    ~Anne Troy

  3. #3
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If this is a sort you use often, you might consider creating a custom sort list. See help file for info.

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
  •