| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting a six digit number by terminal digit
Thanks, that's what I ended up doing.
"Duke Carey" wrote in message ... Can't see any way to do what you'd like to do, except by creating a helper column with a formula akin to what I offered. Sorry "Brian" wrote: Thanks Duke. I was trying to avoid that. Wondering if there is anyway to sort data in place? "Duke Carey" wrote in message ... In an adjacent cell use this formula - (assuming the number is in A2) =right(A2,2)&mid(A2,3,2)&left(A2,2) Copy the formula down & then sort on that column "Brian" wrote: The data is actually all together, ie 123456. NOT 12 34 56. Thanks. "starguy" wrote in message ... I am not sure that either you have space after two digits or not. with spaces digits would be like this 12 34 56 without spaces digits would be 123456 confirm that what type of data you have because method would be different for both type of digits. Brian Wrote: Howdy All, I have record information in a spreadsheet that contains terminal digit record numbers. Terminal digit is a filing system that uses 3 sets of 2 numbers, example 12 34 56. But the system works kind of in reverse, 56 is the first number you look at, then 34, then 12. I have these record numbers in column B. I need to sort them by terminal digit, meaning by the last 2 numbers first, then by the middle 2, and lastly by the first 2. Can someone help me out with a simple solution? Thanks, Brian -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=570746 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to input a 12 digit number into a cell | New Users to Excel | |||
| How do i save a 12 digit number in a .csv document in excell? | Excel Discussion (Misc queries) | |||
| Display a 16 digit number | Excel Discussion (Misc queries) | |||
| Letters and 000s in front of actual number not sorting correctly | Excel Discussion (Misc queries) | |||
| When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) | |||
Hybrid Mode
