Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a column of dates that I produced by putting in the first date. Then
the next and following were simply a formula =SUM(A4+7) and so on for five years of Sundays. I wanted to have two for each sunday I could have them sorted by AM or PM so I duplicated the list and put AM in the next column beside the first 5 years of Sundays and PM beside the next five years. I then sorted with column A (dates) descending and column B (AM/PM) descending. I expected to get 01/01/2000 AM and then 01/01/2000 PM under each other and so on but the formulated column would not sort. I tried a sample of five dates manually and they sorted fine but not when the dates are produced by a formula. I do not want to have to type in five years of dates as that is the reason we have formulas. How do I sort the formulated column??????? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
hide column but show chart | Charts and Charting in Excel | |||
Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
Help with Charting My Data -- | Charts and Charting in Excel | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
Making Special "Stacked Column" Chart | Charts and Charting in Excel |