Posted to microsoft.public.excel.worksheet.functions

TimJames

external usenet poster

Posts: 16

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sorting two lists	Blah	Excel Discussion (Misc queries)	1	May 17th 06 07:27 PM
Sorting lists	bryce	Excel Discussion (Misc queries)	3	May 12th 06 05:00 PM
Sorting lists	famdamly	Excel Discussion (Misc queries)	2	February 26th 06 09:58 PM
Sorting LISTs	Tia	Excel Discussion (Misc queries)	2	November 22nd 05 05:52 PM
Sorting 2 lists	jtoy	Excel Discussion (Misc queries)	1	July 15th 05 03:36 AM

All times are GMT +1. The time now is 09:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us