Terminal Digits

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I work in a hospital and have occasion to create lists requiring chart
numbers. Those familiar with medical files are familiar with terminal digits.
Is there a way in Excel to make a list in numeric order by terminal digit?
 
I think you'd have to create a 'helper column' that had just the terminal
digit, and sort by the terminal digit then by the full number. To capture
that terminal digit, suppose your chart number is in A2. Then in B2, you
could use =mod(a2,10) to get the final digit from the number (if your
'numbers' are really text, use =right(a2,1) instead of the mod function).
Autofill that formula through the entire column.
HTH. --Bruce
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save data from Notebook: copying to the USB stick using Linux and the command line 0
How do I sort the last 3 digits first and then the first 4 digit?. 2
Sorting a six digit number by terminal digit 10
How can I sort SSNs in Terminal Digit Order using Excel? 19
Formula Help 5
Sort Question 1
Barcode Check Digits 3
Need to extract specific data from a text column 2

Back
Top