| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sort the last 3 digits first and then the first 4 digit?.
I was always trying to sort the list of Medical Records to be retrieved from
filing shelves which is arranged by Termianl Digit Filing system. In our hospital, each patient has a 7 digit unit number and this unit number is devided into two sections of primary number and secondary number. for example. the files are arranged as follows: 2345-678 2346-678 2347-678 ----_--- ----_--- 1234-679 1235-679 I would greatly appreciate if someone could help me to sort numbers in this order. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I sort the last 3 digits first and then the first 4 digit?.
This is one way.
Copy the column of data to a blank column. Data - Text to columns Set the delimiter to be - Sort the columns as needed. "aphriam" wrote: I was always trying to sort the list of Medical Records to be retrieved from filing shelves which is arranged by Termianl Digit Filing system. In our hospital, each patient has a 7 digit unit number and this unit number is devided into two sections of primary number and secondary number. for example. the files are arranged as follows: 2345-678 2346-678 2347-678 ----_--- ----_--- 1234-679 1235-679 I would greatly appreciate if someone could help me to sort numbers in this order. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I sort the last 3 digits first and then the first 4 digit?.
Create a helper column in (column B)
In B1: =--RIGHT(A1,3) copy down as far as needed Select data ranges Data Sort sort by select Column B Ascending Then by Column A Ascending OK When you done delete a helper column "aphriam" wrote: I was always trying to sort the list of Medical Records to be retrieved from filing shelves which is arranged by Termianl Digit Filing system. In our hospital, each patient has a 7 digit unit number and this unit number is devided into two sections of primary number and secondary number. for example. the files are arranged as follows: 2345-678 2346-678 2347-678 ----_--- ----_--- 1234-679 1235-679 I would greatly appreciate if someone could help me to sort numbers in this order. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to replace 12 digits only of 16 digit number. | Excel Discussion (Misc queries) | |||
| How do I convert 9 digit zipcodes to 5 digits? | Excel Discussion (Misc queries) | |||
| Getting the first 3 digits out of 6 digit cells? | Excel Worksheet Functions | |||
| Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel | |||
| I have a col. with 6 digit nos to convert to 3 cols of 2 digits | Excel Discussion (Misc queries) | |||
Linear Mode
