Thread: sorting issue
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Brian Brian is offline
external usenet poster
 
Posts: 683
Default sorting issue

Please ignore. I figured it out. the date field had minutes too. created new
column with =value(left(A1,5)) and was able to sort fine.

"brian" wrote:

I am trying to sort by two columns, a date column and a general column.
Sorted by themselves, all works fine. but if I add a level and sort the
general after the date, the general column is not alphabetical. Any ideas?