LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,805
Default sorting 4 columns

First sort on first three column then sort only on the fourth column. Do
select all the columns together...

Example
If you want to sort the range A1:Z1000 then select the whole range...
Choose the three columns you want to sort on
Sort

If required, choose the range A1:Z1000 again then sort on the fourth column
only.



"canyonhiker" wrote:

I'm trying to sort 4 columns, however sorting 3 is easy - when I try to do
the 4th it changes everything in the other columns and then they are no
longer correct

 
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
help with sorting text in columns to match other columns rkat Excel Discussion (Misc queries) 1 August 11th 06 03:42 AM
Sorting columns Tom Excel Discussion (Misc queries) 3 May 4th 06 02:22 PM
sorting more than 3 columns saybut Excel Discussion (Misc queries) 4 February 20th 06 12:03 PM
Sorting columns Petterq Excel Worksheet Functions 2 October 10th 05 08:20 PM
Sorting Columns JohnT Excel Worksheet Functions 3 March 5th 05 10:15 PM


All times are GMT +1. The time now is 02:11 AM.

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

About Us

"It's about Microsoft Excel"