| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I sort numbers based on last two digits?
I am working on a hospital project. Casenotes are stored by a 3 dual digit
system eg. 23 44 67 with casenotes ending in ** ** 68 and ** ** 66 stored adjacent. Get it? I have a load of notes to look up so I need to sort out the casenote numbers I have by the last two digits in order to simplify the manual search for the notes. Is there any way I could program the Excel list I have to sort the last two digits of the casenote numbers into numerical order? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I sort a list of numbers by the last 4 digits? | Excel Worksheet Functions | |||
| How can I sort a list of numbers by the last 4 digits? | Excel Discussion (Misc queries) | |||
| sort by numbers of digits in cells | Excel Worksheet Functions | |||
| Auto insert page breaks in Excel, based on a sort of numbers | Excel Discussion (Misc queries) | |||
| sort numbers based on initial digit. | Excel Discussion (Misc queries) | |||
Threaded Mode
