Help for Medical Records sorting

  • Thread starter Thread starter Gerry St
  • Start date Start date
G

Gerry St

I know this has been queried before but unfortunately, I cannot locat
it. Our office deals with medical records numbers and we often hav
need to sort them numerically. An example of these numbers would b
09275361. The sort required for this would need to first,consider th
last two numbers (61) then the 5th and 6th numbers (53) then the 3r
and 4th number (27) and finally the 1st and 2nd numbers (09). The firs
digit (0) requires that the field be formatted as text as it essentia
that it be shown in the final result. As speed is of the essence whe
this sorting needs to be done, I am looking for the easiest way t
enter this into a spreadsheet (if possible) without using a helpe
column, which I would assume would require manual entry
 
You're probably going to have to use helper columns to use the sort
command.
This is pretty easy and does not take much effort beyond copying the
formulas down the sheet:
If your # is in A1 the formulas would be:
=right(A1,2) [get the 2 characters on the right of the value]
=mid(A1,5,2) [get the 2 characters starting from the 5th position]
=mid(A1,3,2) [get the 2 characters starting from the 3rd position]
=left(A1,2) [get the first 2 characters from the left of the value]
 
A helper column doesn't need manual entry. You just create one formula and
copy it down the column. For your helper column, use:

=right(a1,2)&mid(a1,5,2)&mid(a1,3,2)&left(a1,2)

Regards,
Fred
 
Amish, I thank you for your quick reply and solution. I greatly
appreciate it.
Gerry St

Amish;944573 said:
You're probably going to have to use helper columns to use the sort
command.
This is pretty easy and does not take much effort beyond copying the
formulas down the sheet:
If your # is in A1 the formulas would be:
=right(A1,2) [get the 2 characters on the right of the value]
=mid(A1,5,2) [get the 2 characters starting from the 5th position]
=mid(A1,3,2) [get the 2 characters starting from the 3rd position]
=left(A1,2) [get the first 2 characters from the left of the value]


On Apr 9 said:
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.
Click to expand...
Click to expand...
 
Back
Top