LinkBack URL
About LinkBacks
Reply With QuoteChester
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.
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 ...
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!
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.
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
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
St. Francis of AssisiStart by doing what's necessary; then do what's possible; and suddenly you are doing the impossible.
Thanks!
I appreciate the help...and yes I did mean numerical order. Thanks again.
Posting Permissions
Bookmarks