Results 1 to 5 of 5

Thread: Sorting (2000)

  1. #1
    Lounger
    Join Date
    Jan 2001
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting (2000)

    I need to sort columns by the 4th character. There are 9 characters total, a combination of letters and numbers. Any advise?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Sorting (2000)

    Create a column which can obtain the 4th character of the column you want to use and the sort on th enew column.

    If you want the 4th character of column A, in the new column use the formula

    =MID(An,4,1) ,

    wher n is the row number.

    Andrew C

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sorting (2000)

    Say that you want to sort A1:A37 by the 4th character. We'll use column B for this; insert an empty column if necessary.
    Select cell B1 and enter the formula =Mid(A1,4,1)
    Fill down to B37.
    Select A1:B37, select Data | Sort... and specify that you want to sort on column B; in this example, there is no column header row.
    If you wish, you can hide the auxiliary column.

  4. #4
    Lounger
    Join Date
    Jan 2001
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting (2000)

    What does the 1 mean at the end of the formula?

  5. #5
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Sorting (2000)

    It means that you just want one character (the 4th) from the original content. You can replace the 1 with any number of your choosing if that is more appropriate for your needs.

    Andrew

Posting Permissions

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