The first column will be the primary sort. The second column is dependant on
the first column. If the value of column 1 changes then the sorting of column
2 will start over again. Perhaps you need to change which column sorts first
and which one second...
--
HTH...

Jim Thomlinson


"urbnjckct" wrote:

I select Data Sort, select the two columns, yes to header row, and the sort
finishes but only partially correct. the first column sorts fine, and the
second almost sorts fine with one weird exception: there is a small part of
the 2nd column data that sorts through W and then starts again at A. I've
sorted by the 2nd column ONLY, and it sorts correctly. I've copied the data
range into another worksheet and the same problem occurs. there are no
leading spaces in the data, and it's all alpha.