Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CREATE CUSTOM SORT IN EXCEL
How do I sort the following text; EP2323A-01, EP2323A-02, EP2323A-03,
EP2323A-04, EP2323A-05, EP2323B-01, EP2323B-02, EP2323B-03, EP2323B-04, EP2323B-05....EP2323F-05. when it is not in any particular order? I want to sort by the number's 01 first then the letter A-F. Then the number's 02 and then letters A-F. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CREATE CUSTOM SORT IN EXCEL
You could extract those final two digits into a helper column with
this: =RIGHT(A1,2) assuming your data is in A1, and copy this down. Include the helper column within your sort range and sort on that as the first field and your data as the second field. Hope this helps. Pete On Nov 13, 2:49*pm, Grayhair wrote: How do I sort the following text; EP2323A-01, EP2323A-02, EP2323A-03, EP2323A-04, EP2323A-05, EP2323B-01, EP2323B-02, EP2323B-03, EP2323B-04, EP2323B-05....EP2323F-05. when it is not in any particular order? I want to sort by the number's 01 first then the letter A-F. Then the number's 02 and then letters A-F. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CREATE CUSTOM SORT IN EXCEL
hi,
You need 2 helper columns and assuming your data in column A put this in b1 and drag down =RIGHT(A1,2) Then this in c1 and drag down =MID(A1,7,1) Now select all 3 columns and sort first on column B ascending and a secondary sort on column C ascending. You will probably be prompted if you want to sort anything that looks like a number as a number. Click OK Delete or hide the helper columns. Mike "Grayhair" wrote: How do I sort the following text; EP2323A-01, EP2323A-02, EP2323A-03, EP2323A-04, EP2323A-05, EP2323B-01, EP2323B-02, EP2323B-03, EP2323B-04, EP2323B-05....EP2323F-05. when it is not in any particular order? I want to sort by the number's 01 first then the letter A-F. Then the number's 02 and then letters A-F. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Custom Sort Error | Excel Discussion (Misc queries) | |||
Excel Charts - Create a custom data label | Charts and Charting in Excel | |||
How do I create a custom font color in Excel? | Excel Discussion (Misc queries) | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
how do i create a custom calendar in excel? | Excel Discussion (Misc queries) |