G
Guest
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.
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.