Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jenn
 
Posts: n/a
Default sort by more than 3 columns

How can I sort by a, then b, then c, then d, e...?
  #2   Report Post  
CarlosAntenna
 
Posts: n/a
Default

sort first by a, b, c
then sort again by d, e

-- Carlos

"jenn" wrote in message
...
How can I sort by a, then b, then c, then d, e...?



  #3   Report Post  
Dana DeLouis
 
Posts: n/a
Default

How to sort more than three columns in Excel
http://support.microsoft.com/default...b;en-us;268007

HTH :)
--
Dana DeLouis
Win XP & Office 2003


"jenn" wrote in message
...

How can I sort by a, then b, then c, then d, e...?



  #4   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Sort by the least significant column first, so if you would sort A:D, select
A:D, sort by column D, select A:D then sort again by A, B and C


Regards,

Peo Sjoblom

"jenn" wrote:

How can I sort by a, then b, then c, then d, e...?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How do I sort using text located in different columns? Neil Excel Discussion (Misc queries) 4 May 2nd 05 07:32 PM
sort column data with hidden columns - excel 2003 nanimadrina Excel Discussion (Misc queries) 2 April 26th 05 08:27 PM
Organize and sort columns J Excel Discussion (Misc queries) 1 March 1st 05 12:17 AM
How to sort random numbers in columns webehere Excel Discussion (Misc queries) 3 January 15th 05 12:24 PM
ALLOW ROW 1 AS HEADER ROW... NOT PART OF DATA SORT OF ANY COLUMNS. bro. Billy New Users to Excel 4 December 11th 04 12:01 AM


All times are GMT +1. The time now is 08:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"