| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I sort a column in Excel by the last digit in each field
I'm trying to sort a large column of 6 digit characters by the last character
in each field. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I sort a column in Excel by the last digit in each field
Add a column to the right of that column.
Use a formula like: =right(a1,1) to get that last digit. Then sort your range by this column. When you're done, delete this column. jmdyt wrote: I'm trying to sort a large column of 6 digit characters by the last character in each field. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort the last 3 digits first and then the first 4 digit?. | Excel Worksheet Functions | |||
| how do i sort formated (colour) field in excel? | Excel Discussion (Misc queries) | |||
| How can I sort SSNs in Terminal Digit Order using Excel? | Excel Worksheet Functions | |||
| In Excel, how do I sort a column by the LAST digit of the data? | Excel Discussion (Misc queries) | |||
| Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel | |||
Linear Mode
