PC Review


Reply
Thread Tools Rate Thread

Column Sorting

 
 
trvlnmny
Guest
Posts: n/a
 
      21st Feb 2010
I am using W XP & Excel 2003. I would like to know if there is a way
to sort on more than 3 columns? If so how is it done?
Thanks for the help.
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      21st Feb 2010
You can use data|sort as many times as you need. Sort by the 3 least important,
then the next 3, then the next 3, ..., until you get to the 3 most important.

Maybe you could even record a macro when you do it once (er, as many as you need
to) manually. Then just re-run that macro when you need to do it again.

trvlnmny wrote:
>
> I am using W XP & Excel 2003. I would like to know if there is a way
> to sort on more than 3 columns? If so how is it done?
> Thanks for the help.


--

Dave Peterson
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Listview Column Header AutoSize & column sorting Ed Kramer Microsoft C# .NET 1 29th Aug 2008 11:02 PM
Sorting a Pivot Table Column that is not the first column... susanohkwon@gmail.com Microsoft Excel Worksheet Functions 1 10th Oct 2007 09:02 PM
Right column doesn't change when sorting left column. =?Utf-8?B?bm9ob3Bl?= Microsoft Excel Misc 2 19th Jul 2005 03:27 PM
sorting one column based on another column =?Utf-8?B?TUlOQUwgWlVOS0U=?= Microsoft Access Getting Started 3 6th Jul 2005 07:39 PM
Sorting for column based on another column xxnonexnonexx@tampascanner.info Microsoft Excel Discussion 1 27th Nov 2004 05:05 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:44 AM.