Thread: sorting lists
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TimJames TimJames is offline
external usenet poster
 
Posts: 16
Default 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.