LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 7
Default Help for Medical Records sorting

I know this has been queried before but unfortunately, I cannot locate it. Our office deals with medical records numbers and we often have need to sort them numerically. An example of these numbers would be 09275361. The sort required for this would need to first,consider the last two numbers (61) then the 5th and 6th numbers (53) then the 3rd and 4th number (27) and finally the 1st and 2nd numbers (09). The first digit (0) requires that the field be formatted as text as it essential that it be shown in the final result. As speed is of the essence when this sorting needs to be done, I am looking for the easiest way to enter this into a spreadsheet (if possible) without using a helper column, which I would assume would require manual entry.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula for sorting mailing lists for multiple records per sheet Dave[_10_] Excel Worksheet Functions 0 July 10th 09 10:07 PM
Excel - Sorting for Duplicate Records jen Excel Worksheet Functions 1 October 7th 08 06:59 PM
need help sorting records over multiple worksheets Liz Excel Discussion (Misc queries) 10 November 26th 07 09:26 AM
Autofilter/Sorting Copying Wrong records Sandi Excel Discussion (Misc queries) 3 January 22nd 07 11:28 PM
Sorting Records reese Excel Discussion (Misc queries) 2 April 7th 05 11:02 PM


All times are GMT +1. The time now is 02:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"