Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting
I have data entries in a column as follows: ABC123, DFR234, TRE456 and so
on. What I need to do is to sort this column by the numbers and not alphabetically but retain the letters in the sorted list. Help would be appreciated. Mike |
#2
|
|||
|
|||
If that's the case you would need a help column where you parse the numbers,
then select both columns and sort by the help column, are there always 3 letters followed by the numbers? If so you could use =--MID(A2,4,15) if not you can use =--MID(A2,MATCH(TRUE,ISNUMBER(--MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)),0),15) entered with ctrl + shift & enter -- Regards, Peo Sjoblom "Mike W" wrote in message ... I have data entries in a column as follows: ABC123, DFR234, TRE456 and so on. What I need to do is to sort this column by the numbers and not alphabetically but retain the letters in the sorted list. Help would be appreciated. Mike |
#3
|
|||
|
|||
Peo,
sorted! many thanks for a speedy reply. I could have said the numbers were all preceeded by three letters so the first formula did the trick. Regards, Mike "Peo Sjoblom" wrote in message ... If that's the case you would need a help column where you parse the numbers, then select both columns and sort by the help column, are there always 3 letters followed by the numbers? If so you could use =--MID(A2,4,15) if not you can use =--MID(A2,MATCH(TRUE,ISNUMBER(--MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)),0),15 ) entered with ctrl + shift & enter -- Regards, Peo Sjoblom "Mike W" wrote in message ... I have data entries in a column as follows: ABC123, DFR234, TRE456 and so on. What I need to do is to sort this column by the numbers and not alphabetically but retain the letters in the sorted list. Help would be appreciated. Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
sorting number in ascending order | Excel Discussion (Misc queries) | |||
SORTING question | New Users to Excel | |||
Adding a KeyID column for sorting | New Users to Excel | |||
sorting question | Excel Discussion (Misc queries) |