How do I sort data?

's Computer Specifications

I have a range of data and needed to sort it by more than three types. When
I go to "data" then "sort" it only gives me three different sort types. Is
there any other way that I can sort 4 or more types.

's Computer Specifications

Not unless you use Excel 2007, which is still in beta mode.

Dave
--
Brevity is the soul of wit.

"madobbs" wrote:

> I have a range of data and needed to sort it by more than three types. When
> I go to "data" then "sort" it only gives me three different sort types. Is
> there any other way that I can sort 4 or more types.

's Computer Specifications

Not unless you use Excel 2007, which is still in beta mode.

Dave
--
Brevity is the soul of wit.

"madobbs" wrote:

> I have a range of data and needed to sort it by more than three types. When
> I go to "data" then "sort" it only gives me three different sort types. Is
> there any other way that I can sort 4 or more types.

's Computer Specifications

Sort the least significant items first and then the next group of 3.
So... sort 4, 5, and 6 then sort 1, 2, and 3.
(select all of the data when sorting... items 1 thru 6)
--
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html

"madobbs"
<(E-Mail Removed)>
wrote in message
I have a range of data and needed to sort it by more than three types. When
I go to "data" then "sort" it only gives me three different sort types. Is
there any other way that I can sort 4 or more types.

's Computer Specifications

Sort the least significant items first and then the next group of 3.
So... sort 4, 5, and 6 then sort 1, 2, and 3.
(select all of the data when sorting... items 1 thru 6)
--
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html

"madobbs"
<(E-Mail Removed)>
wrote in message
I have a range of data and needed to sort it by more than three types. When
I go to "data" then "sort" it only gives me three different sort types. Is
there any other way that I can sort 4 or more types.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
data, sort option is grayed. how to sort on a column?	Steve Richter	Microsoft Excel Misc	1	25th Sep 2007 03:25 PM
Pls. reply Sort Data and copy to next coulmn when sort order chang	=?Utf-8?B?c2hpdGFsIHNoYWg=?=	Microsoft Excel Programming	0	19th Aug 2005 10:29 AM
Sort Data and copy to next coulmn when sort data changes	=?Utf-8?B?c2hpdGFsIHNoYWg=?=	Microsoft Excel Programming	0	18th Aug 2005 02:55 PM
Sort Data and copy to next coulmn when sort data changes	=?Utf-8?B?c2hpdGFsIHNoYWg=?=	Microsoft Excel Programming	0	18th Aug 2005 06:48 AM
How do I sort a column of data and have each data row sort accordi	=?Utf-8?B?T2VkYWxpcw==?=	Microsoft Excel Misc	1	17th Mar 2005 11:52 PM