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
|