sorting issue

[Guest]

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?

 

[Guest]

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.

 

[David McRitchie]

Hi Brian,
You would be better off using something like
=INT(A1) to extract the integer value of a timestamp
which would be the date, rather than a text representation.

More information on sorting:
http://www.mvps.org/dmcritchie/excel/sorting.htm
--
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"brian" ...