Putting a list of numbers in chronological order

[cfarley]

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!

 

[Norie]

Chester

Chronological order?

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.

 

[Jonmo1]

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.

 

[brian.wethington]

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.

 

[cfarley]

Thanks!

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