| 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. |
| 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) | |||
Threaded Mode
