View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo[_3_] Sheeloo[_3_] is offline
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