View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
StargateFan StargateFan is offline
external usenet poster
 
Posts: 61
Default Columns not sorting properly.

I'm stumped on this one - I had it happen once before but I don't
recall the fix. When I sort either manually or programmatically via a
recorded script, by name, there's a break in the sort so that I get 2
groups of alphabetically sorted names. In other words, half the
column is sorted A to Z and then after a name beginning with X, then
below that another group starts A-Z. I checked the format of the
celsl and they're all General. I removed all other sorts so as to
just leave either FIRST NAME, LAST NAME sort and tried going back and
forth but the columns remain badly sorted as described.

Anyone know what is the cause of this type of thing?

Thx. :oD