| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can i change the default sort order in excel?
I have some data I am pulling from a system that records days of the week as
M, T, W, H, F, S, and U (Monday, Tuesday . . . . Sunday). I need to sort the list so that it is in the order that the week follows (above) as opposed to alphabetical (the result I get when I use the sort feature). I'm pretty comfortable with everything in Excel except for VB which I fear holds my solution. Does anyone out there have an idea?? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how can i change the default sort order in excel?
I assume your column contains one of the codes you list. You can set up a
custom sort order. Check it out in Help. Then you have to use Data/Sort and specify the custom order for this column (which must also be the 1st key). On Thu, 16 Sep 2004 19:53:05 -0700, kristenlc wrote: I have some data I am pulling from a system that records days of the week as M, T, W, H, F, S, and U (Monday, Tuesday . . . . Sunday). I need to sort the list so that it is in the order that the week follows (above) as opposed to alphabetical (the result I get when I use the sort feature). I'm pretty comfortable with everything in Excel except for VB which I fear holds my solution. Does anyone out there have an idea?? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how can i change the default sort order in excel?
Thank you! That worked like a charm!
"Myrna Larson" wrote: I assume your column contains one of the codes you list. You can set up a custom sort order. Check it out in Help. Then you have to use Data/Sort and specify the custom order for this column (which must also be the 1st key). On Thu, 16 Sep 2004 19:53:05 -0700, kristenlc wrote: I have some data I am pulling from a system that records days of the week as M, T, W, H, F, S, and U (Monday, Tuesday . . . . Sunday). I need to sort the list so that it is in the order that the week follows (above) as opposed to alphabetical (the result I get when I use the sort feature). I'm pretty comfortable with everything in Excel except for VB which I fear holds my solution. Does anyone out there have an idea?? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how can i change the default sort order in excel?
BTW, if you have the actual date in one of the columns (rather than just the
single letter code you show), you can set up a "helper" column containing the formula =WEEKDAY(A1,2) or =WEEKDAY(A1,3). That will return the numbers 1-7 or 0-6, respectively. Then you can sort on this column. On Thu, 16 Sep 2004 21:07:02 -0700, kristenlc wrote: Thank you! That worked like a charm! "Myrna Larson" wrote: I assume your column contains one of the codes you list. You can set up a custom sort order. Check it out in Help. Then you have to use Data/Sort and specify the custom order for this column (which must also be the 1st key). On Thu, 16 Sep 2004 19:53:05 -0700, kristenlc wrote: I have some data I am pulling from a system that records days of the week as M, T, W, H, F, S, and U (Monday, Tuesday . . . . Sunday). I need to sort the list so that it is in the order that the week follows (above) as opposed to alphabetical (the result I get when I use the sort feature). I'm pretty comfortable with everything in Excel except for VB which I fear holds my solution. Does anyone out there have an idea?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change default series line color order | Excel Discussion (Misc queries) | |||
| How to change the column order in Excel table with multiple sort | Excel Discussion (Misc queries) | |||
| Default Sort Order | Excel Worksheet Functions | |||
| excel change default column sort to current selection | Excel Worksheet Functions | |||
| how do I reset the default sort order in excel xp back to blanks . | Excel Discussion (Misc queries) | |||
Hybrid Mode
