Results 1 to 5 of 5

Putting a list of numbers in chronological order

This is a discussion on Putting a list of numbers in chronological order within the Excel Questions forums, part of the Question Forums category; Hey there. I know how to put a list of numbers in chronological order, but is it possible to do ...

  1. #1
    New Member
    Join Date
    Apr 2006
    Location
    Raleigh, NC
    Posts
    13

    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
    66,050

    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
    32,530

    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.
    Want better/faster responses to your questions?
    Use Excel Jeanie to post samples of your sheet.

    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,723

    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

    Default Thanks!

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

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