Sort twice.

First time sort by D, then the second do your "normal" sort.



wrote:

I have the following table:
2 A 2 A
1 A 2 A
1 B 2 B
1 A 1 A
2 A 1 B
1 B 1 A
2 A 2 B
1 A 2 B
2 A 2 B
2 B 1 B
2 B 1 A
2 B 2 A
2 A 1 A
1 A 1 B
1 B 2 A
1 B 1 B

After I sort on column A, B and C I get:
1 A 1 A
1 A 1 B
1 A 2 A
1 A 2 B
1 B 1 A
1 B 1 B
1 B 2 B
1 B 2 A
2 A 1 B
2 A 1 A
2 A 2 A
2 A 2 B
2 A 2 B
2 B 1 B
2 B 1 A
2 B 2 A

I want to include column D into the sort. Right now the sort is wrong
on row 7 and after that few more rows. How to sort so that column D is
sorted and column A, B and C also remain sorted? Thanks.

--

Dave Peterson