| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting lists
A standard Excel ascending sort produces... 1990CJ000123 1991CJ000124 1991DJ000137 1992CJ000124 1992CJ000125 1992CJ000126 1992DJ000124 1993CJ000125 It doesn't appear that any special sorting methods are necessary. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming - check out Special Sort) "TimJames" wrote in message I have a list with entries like so: 1990CJ000123 1991CJ000124 1992DJ000124 1993CJ000125 1992CJ000124 1992CJ000125 1992CJ000126 1991DJ000137 How can I sort the lists by the year (IE 1991, etc) but make sure the DJ's and the CJ's are mixed together? In other words, I do not want the entries that contain CJ to be at the top of the list and the DJ entries to be at the bottom. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting two lists | Excel Discussion (Misc queries) | |||
| Sorting lists | Excel Discussion (Misc queries) | |||
| Sorting lists | Excel Discussion (Misc queries) | |||
| Sorting LISTs | Excel Discussion (Misc queries) | |||
| Sorting 2 lists | Excel Discussion (Misc queries) | |||
Threaded Mode
