Putting a list of numbers in chronological order

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Putting a list of numbers in chronological order

  1. #1
    New Member
    Join Date
    Apr 2006
    Location
    Raleigh, NC
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Putting a list of numbers in chronological order

     
    Hey there. I know how to put a list of numbers in chronological order, but is it possible to do this specific to the 3rd digit in a number. For example, if you have these #'s:
    745678, 923456, 656789, & 834567

    Can you arrange them in chronologic order according to the 3rd digit?
    923456
    834567
    745678
    656789

    Hope this makes sense!

  2. #2
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling
    Posts
    72,950
    Post Thanks / Like
    Mentioned
    13 Post(s)
    Tagged
    0 Thread(s)

    Default

    Chester

    Chronological order?:o

    Isn't that for dates?

    Do you mean numerical order?

    If you do then the only way I can think of doing that would be to extract the 3rd digit to a helper column and use that in the sort.
    If posting code please use code tags.

  3. #3
    MrExcel MVP Jonmo1's Avatar
    Join Date
    Oct 2006
    Location
    Bryan, TX
    Posts
    43,757
    Post Thanks / Like
    Mentioned
    17 Post(s)
    Tagged
    0 Thread(s)

    Default

    You could with a helper column...
    If those numbers are in column A, in B1 put a formula

    =--Mid(A1,3,1)

    Then sort by column B.
    Use the MrExcel HTML Maker to post nicely formatted tables in your forum posts.
    Find a link in post number 31

    The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious.

    Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.
    Ferris Bueller A.K.A. John Hughes, 1986

  4. #4
    Board Regular brian.wethington's Avatar
    Join Date
    Jul 2006
    Location
    Irving TX
    Posts
    1,739
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    you could use this formula in a helper column

    =RIGHT(A1,LEN(A1)-2)

    Drag down as needed then sort and then if you would like you can remove the formula.
    Brian

    Start by doing what's necessary; then do what's possible; and suddenly you are doing the impossible.
    St. Francis of Assisi

  5. #5
    New Member
    Join Date
    Apr 2006
    Location
    Raleigh, NC
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Thanks!

      
    I appreciate the help...and yes I did mean numerical order. Thanks again.

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
  •  

 

 
DMCA.com