Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Terminal Digits
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Terminal Digits
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 "Cheryl B" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mistery digits on excel | Excel Discussion (Misc queries) | |||
excel floating digits error | Excel Discussion (Misc queries) | |||
Lookup the 1st 5 digits | Excel Worksheet Functions | |||
Least number of digits in Y-axis labels | Charts and Charting in Excel | |||
Excel Add-in Use on a Terminal Server | Excel Discussion (Misc queries) |