Thread: Sort isn't working correctly
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike S[_5_] Mike S[_5_] is offline
external usenet poster
  
Posts: 86
Default Sort isn't working correctly
On 11/4/2016 10:28 PM, GARYWC wrote:
The cells in col A and in col B contain the same data.
All cells have a "General" format.
Both columns are unsorted.

I highlight col A and use DATA/SORT/SORT BY COLUMN A/SORT ON VALUES/ORDER A to Z then click OK.
I highlight col B and use DATA/SORT/SORT BY COLUMN B/SORT ON VALUES/ORDER A to Z then click OK.
I expect the cells in both columns to be sorted in the same order but they aren't. (For example: 2008-ITALY001.jpg is in A137 and in B61).
Why isn't sort working correctly?

Can you post the picture somewhere online and then provide a link to it?
Dropbox would work.

Just to be sure, did you run any code to verify that the data is exactly
the same in both columns, e.g.
http://www.techrepublic.com/blog/mic...of-excel-data/


Reply With QuoteReply With Quote