Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting issue
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting issue
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" ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Issue - Any help? | Excel Worksheet Functions | |||
Sorting Issue. Please help | Excel Discussion (Misc queries) | |||
Sorting Issue | Excel Discussion (Misc queries) | |||
sorting issue | Excel Discussion (Misc queries) | |||
sorting issue - help | Excel Discussion (Misc queries) |