| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hard to Sort Sorting
Does any know if you can sort the following by skipping the 4th letter:
RPE3-063Y11/12060E5 RPE3-063C11/12060E5 RPE3-063H11/12060E5 RPE4-063Y11/12060E5 RPE4-063C11/12060E5 RPE4-063H11/12060E5 I would like to know if I can get them to automatically sort into the following way. RPE3-063C11/12060E5 RPE4-063C11/12060E5 RPE3-063H11/12060E5 RPE4-063H11/12060E5 RPE3-063Y11/12060E5 RPE4-063Y11/12060E5 For us the 4 item is a series number and we have parts that have been updated and need to be merged in our system. I thought that this would be an easier way to sort through the items. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hard to Sort Sorting
You could add an extra column and just elminate that character:
=left(a1,3)&mid(a1,5,len(a1)) drag down and sort by that helper column ysuswim wrote: Does any know if you can sort the following by skipping the 4th letter: RPE3-063Y11/12060E5 RPE3-063C11/12060E5 RPE3-063H11/12060E5 RPE4-063Y11/12060E5 RPE4-063C11/12060E5 RPE4-063H11/12060E5 I would like to know if I can get them to automatically sort into the following way. RPE3-063C11/12060E5 RPE4-063C11/12060E5 RPE3-063H11/12060E5 RPE4-063H11/12060E5 RPE3-063Y11/12060E5 RPE4-063Y11/12060E5 For us the 4 item is a series number and we have parts that have been updated and need to be merged in our system. I thought that this would be an easier way to sort through the items. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hard to Sort Sorting
=CODE(MID(A1,9,9)) in a helper column
Sort on the helper column Gord Dibben MS Excel MVP On Wed, 3 Sep 2008 13:14:01 -0700, ysuswim wrote: Does any know if you can sort the following by skipping the 4th letter: RPE3-063Y11/12060E5 RPE3-063C11/12060E5 RPE3-063H11/12060E5 RPE4-063Y11/12060E5 RPE4-063C11/12060E5 RPE4-063H11/12060E5 I would like to know if I can get them to automatically sort into the following way. RPE3-063C11/12060E5 RPE4-063C11/12060E5 RPE3-063H11/12060E5 RPE4-063H11/12060E5 RPE3-063Y11/12060E5 RPE4-063Y11/12060E5 For us the 4 item is a series number and we have parts that have been updated and need to be merged in our system. I thought that this would be an easier way to sort through the items. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i sort a complete worksheet by sorting columns | Excel Worksheet Functions | |||
| sorting and adding cells in different work sheet? (hard stuff) | Excel Discussion (Misc queries) | |||
| Button to sort a range, and sorting 12 columns | Excel Worksheet Functions | |||
| Sort rows without sorting... | Excel Discussion (Misc queries) | |||
| Column matching - sorting. Fairly hard problem, I think. | Excel Discussion (Misc queries) | |||
Linear Mode
