Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sorting/ordering a column by day of the week
i am making a spreadsheet of a weekly schedule, so i need to be able to sort
and order a column not by day AND date (wednesday, January 8, 2010), but simply by day of the week. in 'format cells,' there is no such capacity, and when i sort ascending, it gives me the days in alphabetical order and not in day of the week order. does anyone know how to get excel to order a column from monday to friday (or sunday to saturday)? thanks so much, -- Laura |
#2
|
|||
|
|||
Use a helper column. If dates are in col. A, use:
=WEEKDAY(A2,3) and fill down. Then sort ascending based on this new column. HTH Jason Atlanta, GA -----Original Message----- i am making a spreadsheet of a weekly schedule, so i need to be able to sort and order a column not by day AND date (wednesday, January 8, 2010), but simply by day of the week. in 'format cells,' there is no such capacity, and when i sort ascending, it gives me the days in alphabetical order and not in day of the week order. does anyone know how to get excel to order a column from monday to friday (or sunday to saturday)? thanks so much, -- Laura . |
#3
|
|||
|
|||
You would need a help column, assume the dates are in column A starting in A2
in for instance B2 put =WEEKDAY(A2,2) copy down, select both and sort by B descending, will group all Mondays, Tuesdays and so on Regards, Peo Sjoblom "Laura" wrote: i am making a spreadsheet of a weekly schedule, so i need to be able to sort and order a column not by day AND date (wednesday, January 8, 2010), but simply by day of the week. in 'format cells,' there is no such capacity, and when i sort ascending, it gives me the days in alphabetical order and not in day of the week order. does anyone know how to get excel to order a column from monday to friday (or sunday to saturday)? thanks so much, -- Laura |
#4
|
|||
|
|||
Another option:
If you format your dates as days-Custom number format dddd. Then, you can Sort by Days in this way: Data | Sort | Options Change the first key sort order to the days of the week spelled out. This will also work if you've type Monday, Tuesday, etc. instead of storing dates. tj "Laura" wrote: i am making a spreadsheet of a weekly schedule, so i need to be able to sort and order a column not by day AND date (wednesday, January 8, 2010), but simply by day of the week. in 'format cells,' there is no such capacity, and when i sort ascending, it gives me the days in alphabetical order and not in day of the week order. does anyone know how to get excel to order a column from monday to friday (or sunday to saturday)? thanks so much, -- Laura |
#5
|
|||
|
|||
beautiful... thank you all for your help! this has been driving me crazy at
work for a long time! -L "tjtjjtjt" wrote: Another option: If you format your dates as days-Custom number format dddd. Then, you can Sort by Days in this way: Data | Sort | Options Change the first key sort order to the days of the week spelled out. This will also work if you've type Monday, Tuesday, etc. instead of storing dates. tj "Laura" wrote: i am making a spreadsheet of a weekly schedule, so i need to be able to sort and order a column not by day AND date (wednesday, January 8, 2010), but simply by day of the week. in 'format cells,' there is no such capacity, and when i sort ascending, it gives me the days in alphabetical order and not in day of the week order. does anyone know how to get excel to order a column from monday to friday (or sunday to saturday)? thanks so much, -- Laura |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort by row instead of by column? | Excel Worksheet Functions | |||
Line or bar graphs for tracking stocks profit and loss. | Charts and Charting in Excel | |||
Format an excel column as a date for a 5 day week for a year. | Excel Discussion (Misc queries) | |||
Copying the contents of a column into a chart | Excel Worksheet Functions | |||
Dynamic Column VlookUps Based on Week Number | Excel Worksheet Functions |