Putting a list of numbers in chronological order

Thanks:  0
Likes:  0

# Thread: Putting a list of numbers in chronological order

1. ## 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. 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.

3. 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.

4. 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.

5. ## Thanks!

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

## User Tag List

#### Posting Permissions

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