| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting lists
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sorting lists
Produce a helper column =LEFT(A2,4)&RIGHT(A2,6)
and sort by that. -- David Biddulph "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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sorting lists
Add a helper column with a formula of
=--Left(A1,4) and sort on that column. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "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. |
|
#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. |
| Reply |
| 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) | |||
Linear Mode
