Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting columns on weekdays
Hello, I have a column with a range of subsequent dates. I want to sort them on weekdays, so that all the mondays come first one after the other, then all tuesdays, then all wednesdays and so on... How can I achieve this? Many thanks and greetings from Brugge (Bruges - Belgium), Michel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting columns on weekdays
You might try using a "helper" column. In an unused column, put the following formula in the first cell with a date in your original column: =WEEKDAY(A2,2) The "2" in the formula ensures that Monday is the first day of the week. Drag this formula down your helper column to cover all the cells that have a date in your original column. Then you can sort your data based on the integers in the helper column. HTH, Eric -- ..-------------------: If toast always lands butter-side down, and cats always land on their feet, what happen if you strap toast on the back of a cat and drop it? Steven Wright (1955 - ) "Michel" wrote: Hello, I have a column with a range of subsequent dates. I want to sort them on weekdays, so that all the mondays come first one after the other, then all tuesdays, then all wednesdays and so on... How can I achieve this? Many thanks and greetings from Brugge (Bruges - Belgium), Michel |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting columns on weekdays
You could use another column with a formula like: =weekday(a1,2) You'll see 1 thru 7. 1 is Monday ... 7 is Sunday Then you can sort your data by this helper column. Michel wrote: Hello, I have a column with a range of subsequent dates. I want to sort them on weekdays, so that all the mondays come first one after the other, then all tuesdays, then all wednesdays and so on... How can I achieve this? Many thanks and greetings from Brugge (Bruges - Belgium), Michel -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting columns on weekdays
You've got more replies at your other post, too. Michel wrote: Hello, I have a column with a range of subsequent dates. I want to sort them on weekdays, so that all the mondays come first one after the other, then all tuesdays, then all wednesdays and so on... How can I achieve this? Many thanks and greetings from Brugge (Bruges - Belgium), Michel -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting columns on weekdays
Hello, To all that did reply: many thanks. I wondered if a solution was possible without adding an extra column. Can you sort the actual colomn in which the dates are, by means of a function or a programming aid, so that the actual column, that contains the dates is sorted without adding another column? Many thanks and greetings, Michel |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting columns on weekdays
There may be a convuluted way, but I don't think that there's anything as straightforward as the suggestion you have. Michel wrote: Hello, To all that did reply: many thanks. I wondered if a solution was possible without adding an extra column. Can you sort the actual colomn in which the dates are, by means of a function or a programming aid, so that the actual column, that contains the dates is sorted without adding another column? Many thanks and greetings, Michel -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
freezing columns labels while sorting columns | New Users to Excel | |||
Sorting columns on weekdays | Excel Worksheet Functions | |||
Sorting Columns | New Users to Excel | |||
help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
Macro for formatting columns with dates, weekdays, and widths? | Excel Programming |